ADD_TIME_ZONE_OFFSET
ZoneId.of
method (America/New_York, +02:00, etc.)."2018-03-10T08:55:12.456Z"
"+02:00"
"2018-03-10T10:55:12.456Z"
"2018-03-10T08:55:12.456Z"
"America/New_York"
"2018-03-10T03:55:12.456Z"
"2018-03-10T08:55:12.456Z"
""
null
"2018-03-10T08:55:12.456Z"
"Invalid Zone Id"
null
BETWEEN
DATE_DIFF
DATE_DIFF_PRECISE
DATE_DIFF_PRECISE(UNIT, TIMESTAMP1, TIMESTAMP2)
UNIT
The unit of time of the calculation. TIMESTAMP1, TIMESTAMP2
The two timestamps used in the calculation
(timestamp2-timestamp1)
> SELECT DATE_DIFF_PRECISE('day',TO_DATE('2018-01-01 00:00:00.000'),
TO_DATE('2018-01-09 12:00:00.000'))FROM “Bid_Requests”;
- > 8.5
DATE_FORMAT
yyyy-MM-dd HH:mm:ss
will output strings in the format 2017-07-23 14:33:54
. yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
will output strings in the format 2017-07-23T14:33:54.756Z
."2018-03-10T08:55:12.456Z"
"yyyy/MM/dd HH:mm:ss.SSS"
"2018/03/10 08:55:12.456"
"2018-03-10T08:55:12.456Z"
"yyyy/MM/dd"
"2018/03/10"
"2018-03-10T08:55:12.456Z"
"HH:mm:ss.SS"
"08:55:12.45"
"2018-03-10T08:55:12.456Z"
"E"
"Sat"
PARSE_DATE
yyyy-MM-dd HH:mm:ss
will output strings in the format 2017-07-23 14:33:54
. yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
will output strings in the format 2017-07-23T14:33:54.756Z
."2017-09-25 22:11:00"
"yyyy-MM-dd HH:mm:ss"
"2017-09-25T22:11:00Z"
"2018-03-19"
"yyyy-MM-dd"
"2018-03-19T00:00:00Z"
"2018_Mar_21_17:59:05.689"
"yyyy_MMM_dd_HH:mm:ss.SSS"
"2018-03-21T17:
59:05.689Z"
"2018_Mar_21"
"yyyy_MMM_dd"
"2018-03-21T00:00:00Z"
"2018_Mar_21_24:59:05.689 America/Los_Angeles"
"yyyy_MMM_dd_kk:
mm:ss.SSS VV"
"2018-03-21T07:
59:05.689Z"
PRESTO_DATE_DIFF
PRESTO_DATE_DIFF(UNIT, TIMESTAMP1, TIMESTAMP2)
UNIT
The unit of time of the calculation. TIMESTAMP1, TIMESTAMP2
The two timestamps used in the calculation
(timestamp2-timestamp1)
timestamp2-timestamp1)
, expressed in terms of unit
. TO_UNIX_EPOCH_MILLIS
"2018-03-10T08:55:12.456Z"
1520672112456
TO_UNIX_EPOCH_SECONDS
"2018-03-10T08:55:12.456Z"
1520672112
UNIX_EPOCH_TO_DATE
1520672112456
"2018-03-10T08:55:12.456Z"
1520672112
"2018-03-10T08:55:12Z"
1520672112456000
"2018-03-10T08:55:12.456Z"
1520672112456000000
"2018-03-10T08:55:12.456Z"