Datetime to Timestamp directive

Owned by Robin Rielley
Last updated: Mar 17, 2021
1 min read

The DATETIME-TO-TIMESTAMP directive was introduced in CDAP 6.4.0.

The DATETIME-TO-TIMESTAMP directive converts a datetime value to timestamp with the given time zone.

Syntax

datetime-to-timestamp :column 'timezone'

Usage Notes

The DATETIME-TO-TIMESTAMP directive converts datetime values to timestamp values using the given time zone (UTC by default). Time zone can be region based string like America/Los_Angeles, Europe/Paris, simple offsets like +08:00, or prefix and offset like UTC+01:00, GMT+08:00, UT+04:00.

If the column is null applying this directive is a no-op.

Examples

datetime-to-timestamp :col1 'UTC-08:00'

datetime-to-timestamp :col2 'America/Los_Angeles'

Created in 2020 by Google Inc.