You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2016/05/19 16:21:13 UTC
[jira] [Resolved] (TRAFODION-1807) Support ISO8601 timezone
specification in datetime values
[ https://issues.apache.org/jira/browse/TRAFODION-1807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma resolved TRAFODION-1807.
-------------------------------------
Resolution: Fixed
Fix Version/s: 2.0-incubating
TZ diff specification has been added:
>>select cast('2015-05-31T10:11:12.123-05:00' as timestamp) from t;
(EXPR)
--------------------------
2015-05-31 15:11:12.123000
--- 1 row(s) selected.
+
>>select cast('2015-05-31T10:11:12.123+05:00' as timestamp) from t;
(EXPR)
--------------------------
2015-05-31 05:11:12.123000
--- 1 row(s) selected.
>>
> Support ISO8601 timezone specification in datetime values
> ----------------------------------------------------------
>
> Key: TRAFODION-1807
> URL: https://issues.apache.org/jira/browse/TRAFODION-1807
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
> Fix For: 2.0-incubating
>
>
> ISO8601 datetime syntax includes specification of timezone designator.
> Format:
> YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00)
> TZD = time zone designator (Z or +hh:mm or -hh:mm)
> Support for 'Z' syntax is already available in trafodion. This indicates
> that a time is specified in UTC.
> This JIRA is to enhance to support timezone offset (+hh:mm, -hh:mm).
> Timezone definition from ISO8601 specification:
> Times are expressed in UTC (Coordinated Universal Time), with a special UTC designator ("Z").
> Times are expressed in local time, together with a time zone offset in hours and minutes. A time zone offset of "+hh:mm" indicates that the date/time uses a local time zone which is "hh" hours and "mm" minutes ahead of UTC. A time zone offset of "-hh:mm" indicates that the date/time uses a local time zone which is "hh" hours and "mm" minutes behind UTC.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)