Datatype used for time in database

Hi,

You can Time datatype in MS SQL or MYSQL database.

+3

Hi Madhu V,

time datatype is designed to used for time in database table.

Data type	Format	Range	Accuracy	Storage size (bytes)
time	hh:mm:ss[.nnnnnnn]	00:00:00.0000000 through 23:59:59.9999999	100 nanoseconds	3 to 5

For more details:

https://learn.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=sql-server-ver16

Hope, this will help you!

+3

Data type:time

+2

For Time data Store you need to use Datatype : Time.

+2