Generates a Datetime value from the following inputs of Integer type: year, month, day, hour, minute, and second.

Integer literal values:

dateformat(datetime(2015,02,15, 2, 4, 0),'yyyy-MM-dd:HH:mm:ss')

Output: Returns the formatted date value: 2015-02-15:02:04:00.

Column reference values:

dateformat(datetime(myYear, myMonth, myDay, myHour, myMin, mySec),'MMM yyyy - HH:MM:SS')


Output:
Generates date values where:

dateformat(datetime(year_integer_col,month_integer_col,day_Integer_col, hour_Integer_col, minute_Integer_col,second_Integer_col  ),'date_format_string')


ArgumentRequired?Data TypeDescription
year_integer_colYintegerName of column or Integer literal representing the year value to apply to the function
month_integer_colYintegerName of column or Integer literal representing the month value to apply to the function
day_integer_colYintegerName of column or Integer literal representing the day value to apply to the function
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 day second to apply to the function
date_format_stringYstringString literal identifying the date format to apply to the value

year_integer_col

Integer literal or name of the column containing integer values for the year.

 

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

month_integer_col

Integer literal or name of the column containing integer values for the month.

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

day_integer_col

Integer literal or name of the column containing integer values for the day.

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

hour_integer_col

Integer literal or name of the column containing integer values for the hour.

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

minute_integer_col

Integer literal or name of the column containing integer values for the minute.

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

second_integer_col

Integer literal or name of the column containing integer values for the second.

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

date_format_string

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

For more information, see DATEFORMAT Function.

Example - date and time functions