tweakstreet-logo
  • Enter search terms

Datetime Parser

Function parsing strings to datetimes

Evaluation

This expression evaluates to a function of the form:

(string x) -> datetime

The function is consistent with parser semantics used for string to data conversion, for example by the CSV Input step.

Processing

String x is converted into a datetime using the given pattern, locale, and default timezone. The resulting datetime value is returned.

If x is equal to the configured nil value, nil is returned.

If x is nil, nil is returned.

Settings

Name Type Description
Pattern
 string

A Java DateTimeFormatter pattern. Example patterns below:

Data Pattern
2018-12-21T14:32:14Z uuuu-MM-dd'T'HH:mm:ssZZZZZ
2018-12-21T14:32:14+01:00 uuuu-MM-dd'T'HH:mm:ss.SSSZZZZZ
uses default timezone setting
2018-12-21T14:32:14+01:00 uuuu-MM-dd'T'HH:mm:ss.SSSVV
uses offset-based timezone
2018-12-21T14:32:14 Europe/Berlin uuuu-MM-dd'T'HH:mm:ss.SSS VV
2018-12-21 14:32:14.123 uuuu-MM-dd HH:mm:ss.SSS
Fri, 21 Dec 2018 14:32:14 CET EEE, dd MMM uuuu HH:mm:ss z
12/21/2018 MM/dd/uuuu
21-Dec-18 02:32:14 PM dd-MMM-uu hh:mm:ss a
Friday, December 21, 2018 EEEE, MMMM dd, uuuu
Locale
 string The locale determines names of months and days of week in the configured pattern.
Default Timezone
 string If the data does not contain timezone information, the parsed datetime is associated with this default timezone.
Trim
 boolean

If true, whitespace from both ends of the string is trimmed before parsing.

If false, the given string is parsed unaltered.
Nil Value
 datetime If the string to parse is equal to this value, the function returns nil.
On this page