Versions Compared

Old Version 2

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version Current

changes.mady.by.user Manon van Tilburg

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Textual corrections
Panel
bgColorwhite

DATETIME


This function converts 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-mmMM-dd hh:mm:ss”. For more info on specifying datetime format patterns, please see Date and time formats or patterns. 


Default formats

For all conversion functions that use a string as parameter, the [format] describes the format in which the input string value parameter is in. When not specifying a format, by default this format is used: 

string to datetime - yyyy-mm

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("202122-0207-18 122024 16:5538:34") results 40", "dd-MM-yyyy hh:mm:ss) converts the string "22-07-2024 16:38:40" in a datetime value of 18-02-2021 12:55:34 (default format is used). DATETIME("19861221 12:02:56", "yyyyMMdd HH:mm:ss") results in a datetime value of 21-12-1986 12:02:56 (specified format is used). .
  • 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.
Info
titleNote

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:40

Back to top