This is an automated email from the ASF dual-hosted git repository.
alamb pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new ce4940d0c8 chore: add test to show current behavior of string to
timezone vs. timestamp to timezone (#11056)
ce4940d0c8 is described below
commit ce4940d0c81e3a1a665bdc5908089c168552fcbd
Author: Chunchun Ye <[email protected]>
AuthorDate: Fri Jun 21 17:30:17 2024 -0500
chore: add test to show current behavior of string to timezone vs.
timestamp to timezone (#11056)
---
datafusion/sqllogictest/test_files/timestamps.slt | 20 ++++++++++++++++++++
1 file changed, 20 insertions(+)
diff --git a/datafusion/sqllogictest/test_files/timestamps.slt
b/datafusion/sqllogictest/test_files/timestamps.slt
index 96d846d449..2216dbfa5f 100644
--- a/datafusion/sqllogictest/test_files/timestamps.slt
+++ b/datafusion/sqllogictest/test_files/timestamps.slt
@@ -2774,6 +2774,26 @@ SELECT '2000-12-01 04:04:12' AT TIME ZONE
'America/New_York';
----
2000-12-01T04:04:12-05:00
+query P
+SELECT '2024-03-30 00:00:20' AT TIME ZONE 'Europe/Brussels';
+----
+2024-03-30T00:00:20+01:00
+
+query P
+SELECT '2024-03-30 00:00:20'::timestamp AT TIME ZONE 'Europe/Brussels';
+----
+2024-03-30T00:00:20+01:00
+
+query P
+SELECT '2024-03-30 00:00:20Z' AT TIME ZONE 'Europe/Brussels';
+----
+2024-03-30T01:00:20+01:00
+
+query P
+SELECT '2024-03-30 00:00:20Z'::timestamp AT TIME ZONE 'Europe/Brussels';
+----
+2024-03-30T00:00:20+01:00
+
## date-time strings that already have a explicit timezone can be used with AT
TIME ZONE
# same time zone as provided date-time
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
