ToDateTime will try to interpret the dateTimeString with the given pattern. If it fails to create a datetime for that string the function dateTime(dateTimeString) will be called to try to create a datetime object with the patterns these function uses. If the dateTimeString is null then null will be returned. If the pattern is null or empty only dateTime(//dateTimeString//) will be called.
ToDateTime( dateTimeString, pattern )
dateTimeString | The string that represents the datetime which should be interpreted with the given pattern. |
---|---|
pattern | The pattern with which the given dateTimeString should be interpreted. The definition for the patterns allowed can be found here. |
Date
toDateTime( '2005-12-24 11:34:56', 'yyyy-MM-dd hh:mm:ss') -> Returns a datetime value for December 24th 2005, AM 11 o'clock 34 minutes and 56 seconds.