Time values represent a clock time without a calendar date. Use timestamp functions when the value must identify an exact moment.
Hour
Returns the hour component of a time using the 24-hour clock.
- Syntax:
Hour(time)
- Requires: a Time value.
- Returns: Numeric, from
0 through 23.
- Best for: grouping appointments or checks by hour.
Minute
Returns the minute component of a time.
- Syntax:
Minute(time)
- Requires: a Time value.
- Returns: Numeric, from
0 through 59.
- Best for: inspecting or validating a stored time.
Second
Returns the second component of a time, including any millisecond fraction.
- Syntax:
Second(time)
- Requires: a Time value.
- Returns: Numeric, from
0 up to but not including 60.
- Best for: integrations or precise time comparisons.
Time
Creates a time from seconds after midnight, or from hour, minute, and optional seconds components.
- Syntax:
Time(seconds), Time(hour, minute), or Time(hour, minute, second)
- Requires: numeric components. Seconds may contain a millisecond fraction; overflow or negative values wrap within a 24-hour day.
- Returns: Time.
- Best for: fixed cut-off times and constructing a time from separate values.
Use ToTimeOfDay when the source is text or a timestamp rather than separate numeric components.
