Generates time values from three inputs of Integer type: hour, minute, and second.

Integer literal values:

dateformat(time(23,58,59),'HH mm ss')

Output: Returns the following map:

23 58 59

Column reference values:

dateformat(time(myHour, myMinute, mySecond), 'hh-mm-ss')

Output: Generates a column of values where:

dateformat(time(hour_integer_col,minute_integer_col,second_integer_col ),'time_format_string')


ArgumentRequired?Data TypeDescription
hour_integer_colYintegerName of column or Integer literal representing the hour value to apply to the function
minute_integer_colYintegerName of column or Integer literal representing the minute value to apply to the function
second_integer_colYintegerName of column or Integer literal representing the second value to apply to the function
time_format_stringYstringString literal identifying the time format to apply to the value

hour_integer_col

Integer literal or name of the column containing integer values for the hour. Values must integers between 0 and 23, inclusive.

 

Required?Data TypeExample Value
YesInteger (literal or column reference)15

minute_integer_col

Integer literal or name of the column containing integer values for the minutes. Values must integers between 0 and 59, inclusive.

Required?Data TypeExample Value
YesInteger (literal or column reference)23

second_integer_col

Integer literal or name of the column containing integer values for the second. Values must integers between 0 and 59, inclusive.

Required?Data TypeExample Value
YesInteger (literal or column reference)45

time_format_string

For more information on supported time formatting strings, see Supported Data Types.

For more information, see DATEFORMAT Function.

Example - date and time functions