You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@vxquery.apache.org by "Preston Carman (JIRA)" <ji...@apache.org> on 2012/06/29 23:58:44 UTC
[jira] [Created] (VXQUERY-43) Date, DateTime, and Time Pointables
Preston Carman created VXQUERY-43:
-------------------------------------
Summary: Date, DateTime, and Time Pointables
Key: VXQUERY-43
URL: https://issues.apache.org/jira/browse/VXQUERY-43
Project: VXQuery
Issue Type: Sub-task
Reporter: Preston Carman
Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
Date (number of days) int
http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
DateTime (number of seconds since 1970) long
http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
Time (number of milliseconds) int
http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
Re: [jira] [Assigned] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by Cezar Andrei <ce...@gmail.com>.
I'm afraid it's not that simple. Make sure you're using a proleptic
gregorian calendar and make sure that year 0 is invalid. Caution is
required when importing/exporting dates from other calendars especialy
before year 1582. See:
http://en.wikipedia.org/wiki/Gregorian_calendar#Proleptic_Gregorian_calendar
Cezar
On Wed, Jul 25, 2012 at 11:35 AM, Preston Carman (JIRA) <ji...@apache.org>wrote:
>
> [
> https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
>
> Preston Carman reassigned VXQUERY-43:
> -------------------------------------
>
> Assignee: Preston Carman
>
> > Date, DateTime, and Time Pointables
> > -----------------------------------
> >
> > Key: VXQUERY-43
> > URL: https://issues.apache.org/jira/browse/VXQUERY-43
> > Project: VXQuery
> > Issue Type: Sub-task
> > Reporter: Preston Carman
> > Assignee: Preston Carman
> > Attachments: TimePointables-07-09.patch, TimePointables2.patch,
> TimePointables3.patch
> >
> >
> > Date types are need to build out all the XQuery functions and Operators.
> Three data types are needed with respect to time: Date, DateTime, and Time.
> Each one is basically a single number can be converted into an ISO8601
> format.
> > Date (number of days) int
> >
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> > DateTime (number of seconds since 1970) long
> >
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> > Time (number of milliseconds) int
> >
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> > The links are for a project that saves the information in a similar
> manner.
>
> --
> This message is automatically generated by JIRA.
> If you think it was sent incorrectly, please contact your JIRA
> administrators:
> https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>
[jira] [Updated] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by "Preston Carman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Preston Carman updated VXQUERY-43:
----------------------------------
Attachment: TimePointables3.patch
Removed the hash and compare functions. Now ready for inclusion.
> Date, DateTime, and Time Pointables
> -----------------------------------
>
> Key: VXQUERY-43
> URL: https://issues.apache.org/jira/browse/VXQUERY-43
> Project: VXQuery
> Issue Type: Sub-task
> Reporter: Preston Carman
> Attachments: TimePointables2.patch, TimePointables3.patch
>
>
> Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
> Date (number of days) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> DateTime (number of seconds since 1970) long
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> Time (number of milliseconds) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by "Preston Carman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13404799#comment-13404799 ]
Preston Carman commented on VXQUERY-43:
---------------------------------------
The patch stores the date, time, and datetime values in their individual components. Each one has standard functions to access the values. Two additional functions are available for calculations: YearMonth and DayTime (similar to the duration values).
> Date, DateTime, and Time Pointables
> -----------------------------------
>
> Key: VXQUERY-43
> URL: https://issues.apache.org/jira/browse/VXQUERY-43
> Project: VXQuery
> Issue Type: Sub-task
> Reporter: Preston Carman
> Attachments: TimePointables2.patch
>
>
> Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
> Date (number of days) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> DateTime (number of seconds since 1970) long
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> Time (number of milliseconds) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by "Preston Carman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Preston Carman updated VXQUERY-43:
----------------------------------
Attachment: TimePointables2.patch
> Date, DateTime, and Time Pointables
> -----------------------------------
>
> Key: VXQUERY-43
> URL: https://issues.apache.org/jira/browse/VXQUERY-43
> Project: VXQuery
> Issue Type: Sub-task
> Reporter: Preston Carman
> Attachments: TimePointables2.patch
>
>
> Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
> Date (number of days) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> DateTime (number of seconds since 1970) long
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> Time (number of milliseconds) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by "Preston Carman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Preston Carman resolved VXQUERY-43.
-----------------------------------
Resolution: Fixed
The basic functionality required by the time related pointables has been completed.
> Date, DateTime, and Time Pointables
> -----------------------------------
>
> Key: VXQUERY-43
> URL: https://issues.apache.org/jira/browse/VXQUERY-43
> Project: VXQuery
> Issue Type: Sub-task
> Reporter: Preston Carman
> Assignee: Preston Carman
> Attachments: TimePointables-07-09.patch, TimePointables2.patch, TimePointables3.patch
>
>
> Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
> Date (number of days) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> DateTime (number of seconds since 1970) long
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> Time (number of milliseconds) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by "Preston Carman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Preston Carman reassigned VXQUERY-43:
-------------------------------------
Assignee: Preston Carman
> Date, DateTime, and Time Pointables
> -----------------------------------
>
> Key: VXQUERY-43
> URL: https://issues.apache.org/jira/browse/VXQUERY-43
> Project: VXQuery
> Issue Type: Sub-task
> Reporter: Preston Carman
> Assignee: Preston Carman
> Attachments: TimePointables-07-09.patch, TimePointables2.patch, TimePointables3.patch
>
>
> Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
> Date (number of days) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> DateTime (number of seconds since 1970) long
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> Time (number of milliseconds) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (VXQUERY-43) Date, DateTime, and Time Pointables
Posted by "Preston Carman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/VXQUERY-43?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Preston Carman updated VXQUERY-43:
----------------------------------
Attachment: TimePointables-07-09.patch
Updated with a few fixes.
> Date, DateTime, and Time Pointables
> -----------------------------------
>
> Key: VXQUERY-43
> URL: https://issues.apache.org/jira/browse/VXQUERY-43
> Project: VXQuery
> Issue Type: Sub-task
> Reporter: Preston Carman
> Attachments: TimePointables-07-09.patch, TimePointables2.patch, TimePointables3.patch
>
>
> Date types are need to build out all the XQuery functions and Operators. Three data types are needed with respect to time: Date, DateTime, and Time. Each one is basically a single number can be converted into an ISO8601 format.
> Date (number of days) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADate.java?r=338
> DateTime (number of seconds since 1970) long
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ADateTime.java?r=338
> Time (number of milliseconds) int
> http://code.google.com/p/asterixdb/source/browse/branches/asterix_stabilization_temporal_fixes/asterix-om/src/main/java/edu/uci/ics/asterix/om/base/ATime.java?r=338
> The links are for a project that saves the information in a similar manner.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira