EXAMPLE - Unixtime Functions

This example illustrates how you can use functions to manipulate Unix time values in a column of Datetime type.

Source:

date
2/8/16 15:41
12/30/15 0:00
4/26/15 7:07

Transform:


Use the following to generate a column containing the above values as Unix timecode values:

derive type:single value: UNIXTIME (date)

Results:

NOTE: If the source Datetime value does not contain a valid input for one of these functions, no value is returned.

dateunixtime_date
2/8/16 15:411454946120000
12/30/15 0:001451433600000
4/26/15 7:071430032020000
Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation