ToDateCustomFormats

Description

Convert input datetime string to datetime data type, using the first format that matches the string .

Syntax

ToDateCustomFormats(custom_string, format1 [, format2] [, ... , formatN])

Arguments

custom_string - datetime value in a string expression in a custom format 

format - format of the custom string. For formatting information, see http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html

Examples

ToDateCustomFormats('1987-01-11 19:04', 'yyyy-MM-dd','yyyy-MM-dd HH:mm','yyyy-MM-dd HH:mm:ss') returns 1987-01-11T19:04:00Z

Return value datatype

datetime

Impact of null value

If custom_string is null, null is returned.

If format strings are null, an exception is raised.

Feedback and Knowledge Base