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:ss) 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.
Note
The way in which date and time values are displayed in the UI is determined by the date and time display formats, which can be configured per language code. For example the Dutch nl-NL date format could be configured as "dd-MM-yyyy hh:mm:ss", whereas the English en-US date format can be defined as "MM/dd/yyyy hh.mm.ss".
The converted date time in our example could look like "22-07-2024 16:38:40" when displayed in Dutch (nl-NL) and like "07/22/2024 16.38.40" when displayed in English (en-US).
More information about language specific formats can be found in Reference Guide: Language formats.
38:40Back to Top
Overview
Content Tools