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