Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 35 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/datetime/date_in.sql b/yql/essentials/tests/sql/suites/datetime/date_in.sql
new file mode 100644
index 0000000000..158c08c964
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/datetime/date_in.sql
@@ -0,0 +1,35 @@
+/* postgres can not */
+select cast("1970-01-01" as date),cast(cast("1970-01-01" as date) as string);
+select cast("2000-04-05" as date),cast(cast("2000-04-05" as date) as string);
+select cast("2100-02-29" as date),cast(cast("2100-02-29" as date) as string);
+select cast("2100-03-01" as date),cast(cast("2100-03-01" as date) as string);
+
+select cast("2000-04-05T06:07:08Z" as datetime),cast(cast("2000-04-05T06:07:08Z" as datetime) as string);
+select cast("2000-04-05T06:07:08Z" as timestamp),cast(cast("2000-04-05T06:07:08Z" as timestamp) as string);
+select cast("2000-04-05T06:07:08.9Z" as timestamp),cast(cast("2000-04-05T06:07:08.9Z" as timestamp) as string);
+select cast("2000-04-05T06:07:08.000009Z" as timestamp),cast(cast("2000-04-05T06:07:08.000009Z" as timestamp) as string);
+
+select cast("P" as interval),cast(cast("P" as interval) as string);
+select cast("P1D" as interval),cast(cast("P1D" as interval) as string);
+select cast("-P1D" as interval),cast(cast("-P1D" as interval) as string);
+select cast("PT2H" as interval),cast(cast("PT2H" as interval) as string);
+select cast("PT2H3M" as interval),cast(cast("PT2H3M" as interval) as string);
+select cast("PT3M" as interval),cast(cast("PT3M" as interval) as string);
+select cast("PT3M4S" as interval),cast(cast("PT3M4S" as interval) as string);
+select cast("PT4S" as interval),cast(cast("PT4S" as interval) as string);
+select cast("PT0S" as interval),cast(cast("PT0S" as interval) as string);
+select cast("PT4.5S" as interval),cast(cast("PT4.5S" as interval) as string);
+select cast("PT4.000005S" as interval),cast(cast("PT4.000005S" as interval) as string);
+select cast("P1DT2H3M4.5S" as interval),cast(cast("P1DT2H3M4.5S" as interval) as string);
+
+select cast("2105-12-31" as date),cast(cast("2105-12-31" as date) as string);
+select cast("2106-01-01" as date),cast(cast("2106-01-01" as date) as string);
+
+select cast("2105-12-31T23:59:59Z" as datetime),cast(cast("2105-12-31T23:59:59Z" as datetime) as string);
+select cast("2106-01-01T00:00:00Z" as datetime),cast(cast("2106-01-01T00:00:00Z" as datetime) as string);
+
+select cast("2105-12-31T23:59:59.999999Z" as timestamp),cast(cast("2105-12-31T23:59:59.999999Z" as timestamp) as string);
+select cast("2106-01-01T00:00:00.000000Z" as timestamp),cast(cast("2106-01-01T00:00:00.000000Z" as timestamp) as string);
+
+select cast("P49672DT23H59M59.999999S" as interval),cast(cast("P49672DT23H59M59.999999S" as interval) as string);
+select cast("P49673D" as interval),cast(cast("P49673D" as interval) as string);