Page History

DATETIME

Converts a value of another data type into a datetime. 

Syntax

DATETIME(string value, [format])
DATETIME(date value)

Inputs

• value - The value of the data type that is converted to datetime. 

• format (optional) - The format used for conversion. Format must be enclosed by quotes, e.g. “yyyy-MM-dd hh:mm:ss”. For more info on specifying datetime format patterns, please see Date and time formats or patterns. 

Default formats
When the format is omitted the ISO-8601 date time format yyyy-MM-dd hh:mm:ss (Most to least significant principle) is used for converting the value to a dateTime. 
However we advice to use an explicit dateTime format in your conversion function to avoid any confusion about the format used for conversion.

Return type

• date

ExamplesString to dateTime examples

• DATETIME("22-07-2024 16:38:40", "dd-MM-yyyy hh:mm:22) converts the string "22-07-2024 16:38:40" in a dateTime value.
• DATETIME("20240722 16:38:40", "yyyyMMdd hh:mm:ss") converts the string "20240722 16:38:40" in a dateTime value. 

Date to dateTime example

• Assume we have a date attribute Person.DateOfBirth
  DATETIME(Person.DateOfBirth) converts the date value to a dateTime value by extending the date value with the timestamp 00:00:00.

38:40