You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
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
String 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:40Back to Top