Skip to main content
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.
Last modified on September 7, 2026