Skip to main content

DATETIME

Converts a value to DateTime, returns a DateTime representation. Failure to convert to DateTime will result in a build error.

Syntax​

DateTime? DATETIME(object value)

Example​

DATETIME("2017-06-04 12:36:04")

Will return a DateTime object of the specified value. You can use this to convert column data into DateTime objects.

For example if you have a column (StringDate) that is returning a String data type but should be returning a DateTime to be compatible with your target dataset then you can convert it using DATETIME: 

DATETIME(StringDate)