Changeset: 5f0ca972db85 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5f0ca972db85
Added Files:
sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
Modified Files:
sql/test/sys-schema/Tests/All
Branch: Jun2023
Log Message:
Add new test webExamplesDateTimeFunctionsOperators.test for web page examples
on documentation-Jun2023/user-guide/sql-functions/date-time-functions/
diffs (truncated from 514 to 300 lines):
diff --git a/sql/test/sys-schema/Tests/All b/sql/test/sys-schema/Tests/All
--- a/sql/test/sys-schema/Tests/All
+++ b/sql/test/sys-schema/Tests/All
@@ -15,6 +15,7 @@ webExamplesLogicalFunctionsOperators
webExamplesComparisonFunctionsOperators
webExamplesCastFunctionsOperators
webExamplesMathematicalFunctionsOperators
+webExamplesDateTimeFunctionsOperators
webExamplesUrlFunctions
utilities
diff --git
a/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
b/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
@@ -0,0 +1,498 @@
+statement ok
+SET TIME ZONE interval '+02:00' hour to minute
+
+# Date/Time literal formats
+query T
+select date '2020-09-28'
+----
+2020-09-28
+
+query T
+select {d '2020-09-28'}
+----
+2020-09-28
+
+# next query fails in Mtest.py with error: too many values to unpack (expected
3). It does not fail when used in mclient or via JDBC driver, so possibly an
issue with Mtest.py
+#query T
+#select date '-4712-01-01'
+#----
+#-4712-01-01
+
+query T
+select time '18:40:05'
+----
+18:40:05
+
+query T
+select {t '18:40:05'}
+----
+18:40:05
+
+query T
+select time(6) '18:40:05.123456'
+----
+18:40:05.123456
+
+query T
+select time(3) with time zone '18:40:05.123+02:00'
+----
+18:40:05.123000+02:00
+
+query T
+select timestamp '2020-09-28 18:40:05'
+----
+2020-09-28 18:40:05
+
+query T
+select {ts '2020-09-28 18:40:05'}
+----
+2020-09-28 18:40:05
+
+query T
+select timestamp(6) '2020-09-28 18:40:05.123456'
+----
+2020-09-28 18:40:05.123456
+
+query T
+select timestamp(3) with time zone '2020-09-28 18:40:05.123+02:00'
+----
+2020-09-28 18:40:05.123000+02:00
+
+query T
+select interval '86399' second
+----
+23:59:59
+
+query T
+select {interval '86399' second}
+----
+23:59:59
+
+query T
+select interval '30' day
+----
+30
+
+query T
+select {interval '30' day}
+----
+30
+
+query T
+select interval '6' month
+----
+6
+
+query T
+select {interval '6' month}
+----
+6
+
+query T
+select interval '18:40:05' hour to second
+----
+18:40:05
+
+query T
+select {interval '18:40:05' hour to second}
+----
+18:40:05
+
+query T
+select interval '2 18:40:05.123' day to second(3)
+----
+2 days, 18:40:05
+
+query T
+select {interval '2 18:40:05.123' day to second(3)}
+----
+2 days, 18:40:05
+
+query T
+select interval '2-5' year to month
+----
+29
+
+query T
+select {interval '2-5' year to month}
+----
+29
+
+
+# Date/Time operators
+query T
+select date '2020-09-28' + (interval '1' second * (7 * 24 * 60 * 60))
+----
+2020-10-05
+
+query T
+select date '2020-09-28' - (interval '1' second * (7 * 24 * 60 * 60))
+----
+2020-09-21
+
+query T
+select date '2020-09-28' - interval '7' month
+----
+2020-02-28
+
+query T
+select date '2020-09-28' - date '2020-02-28'
+----
+213
+
+query T
+select time '14:35:45' - time '02:12:24'
+----
+12:23:21
+
+
+# Date/Time functions
+query T
+select century(date '2020-03-22')
+----
+21
+
+query I
+select curdate() > date '2020-03-22'
+----
+1
+
+query I
+select current_date() > date '2020-03-22'
+----
+1
+
+query I
+select current_time() <> timetz '13:16:57.734639+01:00'
+----
+1
+
+query I
+select current_timestamp() <> timestamptz '2020-03-22 13:16:57.734639+01:00'
+----
+1
+
+query I
+select curtime() <> timetz '13:16:57.734639+01:00'
+----
+1
+
+query T
+select sys.date_to_str(date '2020-03-22', '%D %d.%m.%Y')
+----
+03/22/20 22.03.2020
+
+query T
+select sys.date_trunc('month', timestamp '2020-03-22 13:16:57.734639')
+----
+2020-03-01 00:00:00
+
+query T
+select "day"(date '2020-03-22')
+----
+22
+
+query T
+select "day"(interval '3.23' second * (24 * 60 * 60))
+----
+3
+
+query T
+select {fn DAYNAME({d '2020-03-22'})}
+----
+Sunday
+
+query T
+select dayofmonth(date '2020-03-22')
+----
+22
+
+query T
+select dayofweek(date '2020-03-22')
+----
+7
+
+query T
+select dayofyear(date '2020-03-22')
+----
+82
+
+query T
+select decade(date '2027-03-22')
+----
+202
+
+query T
+select sys.epoch(1234567890)
+----
+2009-02-14 01:31:30+02:00
+
+query T
+select sys.epoch(1234567890.456)
+----
+2009-02-14 01:31:30.456000+02:00
+
+query T
+select sys.epoch(timestamp '2009-02-13 23:31:30.0')
+----
+1234567890
+
+query T
+select epoch_ms(timestamp '2009-02-13 23:31:30.0')
+----
+1234567890.000
+
+query T
+select extract(doy from date '2027-03-22')
+----
+81
+
+query T
+select greatest(date '2020-03-22', date '2020-03-25')
+----
+2020-03-25
+
+query T
+select "hour"(timetz '15:35:02.002345+01:00')
+----
+16
+
+query T
+select least(time '15:15:15', time '16:16:16')
+----
+15:15:15
+
+query T
+select local_timezone()
+----
+2:00:00
+
+query I
+select localtime() <> time '13:16:57.734639'
+----
+1
+
+query I
+select localtimestamp() <> timestamp(6) '2020-03-22 13:16:57.734639'
+----
+1
+
+query T
+select "minute"(timetz '15:35:02.002345+01:00')
+----
+35
+
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
