[
https://issues.apache.org/jira/browse/IGNITE-22345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-22345:
----------------------------------------
Description:
According to standard, Feature F411:
_6.35 <datetime value expression>_
we need to support syntax like :
{noformat}
SELECT LOCALTIMESTAMP|LOCALTIME AT TIME ZONE 'America/New_York';
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'America/New_York';
SELECT CURRENT_DATE AT TIME ZONE 'America/New_York';
{noformat}
was:
According to standard :
_6.35 <datetime value expression>_
we need to support syntax like :
{noformat}
SELECT LOCALTIMESTAMP|LOCALTIME AT TIME ZONE 'America/New_York';
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'America/New_York';
SELECT CURRENT_DATE AT TIME ZONE 'America/New_York';
{noformat}
> Sql. Support datetime value expression with appropriate time zone.
> ------------------------------------------------------------------
>
> Key: IGNITE-22345
> URL: https://issues.apache.org/jira/browse/IGNITE-22345
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> According to standard, Feature F411:
> _6.35 <datetime value expression>_
> we need to support syntax like :
> {noformat}
> SELECT LOCALTIMESTAMP|LOCALTIME AT TIME ZONE 'America/New_York';
> SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'America/New_York';
> SELECT CURRENT_DATE AT TIME ZONE 'America/New_York';
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
