aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/datetime/date_tz_bitcast.sql
blob: 77d8f430e112c771fb9afaa2316b946724827275 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
/* postgres can not */
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint8);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int8);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint16);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int16);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint32);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int32);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Uint64);
select bitcast(Yql::TzDate(AsAtom("1,UTC")) as Int64);

select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint8);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int8);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint16);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int16);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint32);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int32);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint64);
select bitcast(Yql::TzDatetime(AsAtom("1,UTC")) as Int64);

select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint8);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int8);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint16);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int16);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint32);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int32);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint64);
select bitcast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int64);