TimeOfDay

The TimeOfDay() function returns the duration that represents the fraction of the day that has elapsed since midnight.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the duration that represents the fraction of the day that has elapsed since midnight.

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

Syntax

TimeOfDay(datetime)

TimeOfDay('2017-03-31T13:27:00') =>Result: '13h27m'

TimeOfDay() =>Result: unknown

Parameters

Name	Type	Required	Description
datetime	date time	☑️	a specified date and time