[jira] [Created] (IGNITE-24832) Sql. Fix documentation about CURRENT_TIME/CURRENT_TIMESTAMP

["Pavel Pereslegin (Jira)" <ji...@apache.org>]

Pavel Pereslegin created IGNITE-24832:
-----------------------------------------

             Summary: Sql. Fix documentation about CURRENT_TIME/CURRENT_TIMESTAMP
                 Key: IGNITE-24832
                 URL: https://issues.apache.org/jira/browse/IGNITE-24832
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Pavel Pereslegin


From current documentation https://ignite.apache.org/docs/ignite3/latest/sql-reference/operators-and-functions#current_time

{noformat}
CURRENT_TIME

Returns the current time in the session time zone, in a value of datatype TIMESTAMP WITH TIME ZONE.

CURRENT_TIMESTAMP

Returns the current date and time in the session time zone, in a value of datatype TIMESTAMP WITH TIME ZONE.
{noformat}

# CURRENT_TIME must return {{TIME WITH TIME ZONE}} (not TIMESTAMP)
# AI3 currently doesn't support TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE data types

We should fix the documentation and note that currently call to {{CURRENT_TIME}}, {{CURRENT_TIMESTAMP}} is equivalent to call {{LOCALTIME}}, {{LOCALTIMESTAMP}} respectively.



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