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)

Reply via email to