Time

Explore what information is available for time.

This type represents a time of day as defined by the ISO 8601 standard.

Defining time values

Although times have no literal syntax, you can use the cast modifier to convert a string into a date-time value.

Local times correspond to the time displayed on a 24-hour clock. They do not represent a specific point on the timeline but rather a time of day. For example, the time 12:00:00 represents noon, regardless of the date or time zone.

Range

The range of valid times is from 00:00:00 to 23:59:59.999999999.

Properties

These are the available properties:

hour integer: The hour of the day, from 0 to 23.
minute integer: The minute of the hour, from 0 to 59.
second integer: The second of the minute, from 0 to 59.
milli integer: The millisecond of the second, from 0 to 999.
micro integer: The microsecond of the second, from 0 to 999999.
nano integer: The nanosecond of the second, from 0 to 999999999.