Parse as Date directive (Deprecated)
Warning: The PARSE-AS-DATE directive is deprecated and will be removed in a future release. Recommendation: Use PARSE-AS-SIMPLEDATE.
The PARSE-AS-DATE directive is for parsing dates using natural language processing.
Syntax
parse-as-date :column ['time-zone']
Usage Notes
The PARSE-AS-DATE directive will apply standard language recognition and translation techniques to produce a list of corresponding dates with optional parse and syntax information.
It recognizes dates described in many ways, including formal dates (02/28/1979
), relaxed dates (oct 1st
), relative dates (the day before next thursday
), and even date alternatives (next wed or thurs
).
This directive will also search for date components within a larger block of text, detect their structure, and create dates.
It will create a new column using the syntax column_1
containing the results of parsing.
If time-zone
is not provided, UTC is used as the timezone.
Examples
Using this record as an example:
{
"create_date": "now",
}
Applying this directive:
parse-as-date :create_date 'US/Eastern'
would result in this record (the actual results depending on when this was run):
Created in 2020 by Google Inc.