aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/bigdate/tz_bytes.sql
blob: 3a79dfdd2d8d49fa538f574c2e3dba16d9f3852a (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
/* postgres can not */
/* syntax version 1 */
select ToBytes(TzDate32("1901-01-01,Europe/Moscow"));
select cast(FromBytes(ToBytes(TzDate32("1901-01-01,Europe/Moscow")),TzDate32) as string);

select ToBytes(TzDatetime64("1901-01-01T01:02:03,Europe/Moscow"));
select cast(FromBytes(ToBytes(TzDatetime64("1901-01-01T01:02:03,Europe/Moscow")),TzDatetime64) as string);

select ToBytes(TzTimestamp64("1901-01-01T01:02:03.456789,Europe/Moscow"));
select cast(FromBytes(ToBytes(TzTimestamp64("1901-01-01T01:02:03.456789,Europe/Moscow")),TzTimestamp64) as string);