在标准SQL中，将TIMESTAMP_MICROS函数与EXTRACT(DATE FROM <timestamp>)一起使用:

In Standard SQL use TIMESTAMP_MICROS function together with EXTRACT(DATE FROM <timestamp>):

SELECT EXTRACT(DATE FROM TIMESTAMP_MILLIS(1494865480000))