You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/08/08 16:26:46 UTC
[GitHub] [arrow-datafusion] waitingkuo opened a new issue, #3080: Should `Cast(UTF-8 AS Timestamp)` apply local time zone?
waitingkuo opened a new issue, #3080:
URL: https://github.com/apache/arrow-datafusion/issues/3080
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
dataufusion v10.0.0 is time zone awareness (i'm in UTC+8)
```bash
❯ select cast('2000-01-01T00:00:00' as timestamp);
+------------------------------------------------------------------+
| CAST(Utf8("2000-01-01T00:00:00") AS Timestamp(Nanosecond, None)) |
+------------------------------------------------------------------+
| 1999-12-31 16:00:00 |
+------------------------------------------------------------------+
1 row in set. Query took 0.004 seconds.
```
while postgresql's is not
```bash
willy=# select cast('2000-01-01T00:00:00' as timestamp);
timestamp
---------------------
2000-01-01 00:00:00
(1 row)
```
**Describe the solution you'd like**
A clear and concise description of what you want to happen.
**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.
**Additional context**
Add any other context or screenshots about the feature request here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Should `Cast(UTF-8 AS Timestamp)` apply local time zone? [datafusion]
Posted by "Dandandan (via GitHub)" <gi...@apache.org>.
Dandandan commented on issue #3080:
URL: https://github.com/apache/datafusion/issues/3080#issuecomment-4590725880
Can no longer reproduce
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
[GitHub] [arrow-datafusion] waitingkuo commented on issue #3080: Should `Cast(UTF-8 AS Timestamp)` apply local time zone?
Posted by GitBox <gi...@apache.org>.
waitingkuo commented on issue #3080:
URL: https://github.com/apache/arrow-datafusion/issues/3080#issuecomment-1209756446
depends on apache/arrow-rs#1936
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Should `Cast(UTF-8 AS Timestamp)` apply local time zone? [arrow-datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #3080:
URL: https://github.com/apache/arrow-datafusion/issues/3080#issuecomment-1770529071
I wonder if this item is now complete
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Should `Cast(UTF-8 AS Timestamp)` apply local time zone? [arrow-datafusion]
Posted by "waitingkuo (via GitHub)" <gi...@apache.org>.
waitingkuo commented on issue #3080:
URL: https://github.com/apache/arrow-datafusion/issues/3080#issuecomment-1771105919
the original issue is fixed now
```bash
❯ select '2000-01-01T00:00:00'::timestamp;
+-----------------------------+
| Utf8("2000-01-01T00:00:00") |
+-----------------------------+
| 2000-01-01T00:00:00 |
+-----------------------------+
1 row in set. Query took 0.002 seconds
```
however it's not yet totally aligned with postgrseql
datafusion
```bash
❯ select '2000-01-01T00:00:00+01:00'::timestamp;
+-----------------------------------+
| Utf8("2000-01-01T00:00:00+01:00") |
+-----------------------------------+
| 1999-12-31T23:00:00 |
+-----------------------------------+
1 row in set. Query took 0.002 seconds.
```
postgresql
```bash
willy=# select '2000-01-01T00:00:00+01:00'::timestamp;
timestamp
---------------------
2000-01-01 00:00:00
(1 row)
```
Looks like Postgresql's behavior is to completely ignore the timezone part while casting string to timestamp
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Should `Cast(UTF-8 AS Timestamp)` apply local time zone? [datafusion]
Posted by "Dandandan (via GitHub)" <gi...@apache.org>.
Dandandan closed issue #3080: Should `Cast(UTF-8 AS Timestamp)` apply local time zone?
URL: https://github.com/apache/datafusion/issues/3080
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org