DATETIME
Converts a value of another data type into a datetime.
Syntax Code Block |
---|
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 dateTimedatetime. However we advice to use an explicit dateTime datetime format in your conversion function to avoid any confusion about the format used for conversion.
Return type
String to dateTime datetime examples - DATETIME("22-07-2024 16:38:40", "dd-MM-yyyy hh:mm:22ss) converts the string "22-07-2024 16:38:40" in a dateTime datetime value.
- DATETIME("20240722 16.38.40", "yyyyMMdd hh.mm.ss") converts the string "20240722 16.38.40" in a dateTime datetime value.
Date to dateTime datetime example - Assume we have a date attribute Person.DateOfBirth
DATETIME(Person.DateOfBirth) converts the date value to a dateTime datetime value by extending the date value with the timestamp 00:00:00.
Info |
---|
| 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-MM38.40MM-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 infromation information about language specific formats can be found in Reference Guide: Language formats. |
38:40 |