[jira] [Created] (IGNITE-25190) CURRENT_TIMESTAMP adjusted to user time zone when cast to VARCHAR

[Vladimir Dmitrienko (Jira)]

Vladimir Dmitrienko created IGNITE-25190:
--------------------------------------------

             Summary: CURRENT_TIMESTAMP adjusted to user time zone when cast to 
VARCHAR
                 Key: IGNITE-25190
                 URL: https://issues.apache.org/jira/browse/IGNITE-25190
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Vladimir Dmitrienko


 

The query {{SELECT CURRENT_TIMESTAMP;}} returns the current timestamp in the 
UTC+0 time zone, as expected. However, when the timestamp is cast to 
{{{}VARCHAR{}}}, it is automatically adjusted to the user's local time zone, 
which leads to inconsistent behavior.

Example:
{code:java}
SELECT CURRENT_TIMESTAMP;
// 2025-04-18T10:19:12.719Z

SELECT CURRENT_TIMESTAMP::VARCHAR;
// 2025-04-18 12:19:17.68 Europe/Warsaw{code}
 

 

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)