diff options
| author | Alexander Smirnov <alex@ydb.tech> | 2024-11-20 11:14:58 +0000 |
|---|---|---|
| committer | Alexander Smirnov <alex@ydb.tech> | 2024-11-20 11:14:58 +0000 |
| commit | 31773f157bf8164364649b5f470f52dece0a4317 (patch) | |
| tree | 33d0f7eef45303ab68cf08ab381ce5e5e36c5240 /yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql | |
| parent | 2c7938962d8689e175574fc1e817c05049f27905 (diff) | |
| parent | eff600952d5dfe17942f38f510a8ac2b203bb3a5 (diff) | |
| download | ydb-31773f157bf8164364649b5f470f52dece0a4317.tar.gz | |
Merge branch 'rightlib' into mergelibs-241120-1113
Diffstat (limited to 'yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql')
| -rw-r--r-- | yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql b/yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql new file mode 100644 index 0000000000..84b60de923 --- /dev/null +++ b/yql/essentials/tests/sql/suites/datetime/date_tz_cast.sql @@ -0,0 +1,47 @@ +/* postgres can not */ +select cast(Yql::TzDate(AsAtom("1,UTC")) as Uint8); +select cast(Yql::TzDate(AsAtom("1,UTC")) as Uint32); +select cast(Yql::TzDate(AsAtom("1,UTC")) as Int32); +select cast(Yql::TzDate(AsAtom("1,UTC")) as Uint64); +select cast(Yql::TzDate(AsAtom("1,UTC")) as Int64); + +select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint8); +select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint32); +select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Int32); +select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Uint64); +select cast(Yql::TzDatetime(AsAtom("1,UTC")) as Int64); + +select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint8); +select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint32); +select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int32); +select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Uint64); +select cast(Yql::TzTimestamp(AsAtom("1,UTC")) as Int64); + +select cast(1ut as TzDate); +select cast(1u as TzDate); +select cast(1 as TzDate); +select cast(1ul as TzDate); +select cast(1l as TzDate); +select cast(-1 as TzDate); +select cast(1/1 as TzDate); +select cast(-1/1 as TzDate); + +select cast(1ut as TzDatetime); +select cast(1u as TzDatetime); +select cast(1 as TzDatetime); +select cast(1ul as TzDatetime); +select cast(1l as TzDatetime); +select cast(-1 as TzDatetime); +select cast(1/1 as TzDatetime); +select cast(-1/1 as TzDatetime); +select cast(1/0 as TzDatetime); + +select cast(1ut as TzTimestamp); +select cast(1u as TzTimestamp); +select cast(1 as TzTimestamp); +select cast(1ul as TzTimestamp); +select cast(1l as TzTimestamp); +select cast(-1 as TzTimestamp); +select cast(1/1 as TzTimestamp); +select cast(-1/1 as TzTimestamp); +select cast(1/0 as TzTimestamp); |