Google Dataprep Date Serial Number

Question

In Google Dataprep when I apply min() to a date it gives a long serial number e.g. 1304985600000. I'm trying to get the first order date of a customer but I can't seem to do anything with this number

Thanks

score 2 · Accepted Answer · answered Jan 13 '18 at 08:43

2

It's a UNIX timestamp represented in milliseconds. With this value in BigQuery, simply do:

SELECT TIMESTAMP_MILLIS(1304985600000)

Output:

Row f0_  
1   2011-05-10 00:00:00.000 UTC

answered Jan 13 '18 at 08:43

Graham Polley

14,393
4
44
80

score 1 · Answer 2 · answered Feb 10 '18 at 12:37

1

You can convert the unix timestamp to a Date in Cloud Dataprep using the UNIXTIMEFORMAT function: https://cloud.google.com/dataprep/docs/html/UNIXTIMEFORMAT-Function_57344709

answered Feb 10 '18 at 12:37

Lars Grammel

1,999
16
21

Google Dataprep Date Serial Number

2 Answers2