Mailing-List: contact dev-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
MIME-Version: 1.0
In-Reply-To: <D244F2FC-B1D4-46CB-AABD-121309867E92@apache.org>
References: <CAA9eHv0uvELvP-C2cegvdXicYz76cQ74fSG9UGiiEvLay5JBvw@mail.gmail.com>
 <CAN_YF5xKSjuD+QnuA-WvCFyL5ehzVBELT7QT+zS413dEni350g@mail.gmail.com> <D244F2FC-B1D4-46CB-AABD-121309867E92@apache.org>
From: Preston Carman <prestonc@apache.org>
Date: Tue, 7 Jun 2016 22:44:21 -0700
Message-ID: <CAA9eHv0vmhq7BuA5Kr_PB-bU1yGfRmEBBinNaPTWVzg6vNmcsw@mail.gmail.com>
Subject: Re: Datetime to Unix Timestamp
To: dev@asterixdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
archived-at: Wed, 08 Jun 2016 05:44:25 -0000

It would be nice to be able to get the numeric value used to store the
different time units. It seems that UNIX timestamp only refers to
datetime in seconds. Although the datetime format in AsterixDB is
stores a datetime in milliseconds. We could come up with a better
function name. These are the ones I am using in the current patch.

UNIX_TIME_FROM_DATE_IN_DAYS
UNIX_TIME_FROM_DATETIME_IN_SECS
UNIX_TIME_FROM_DATETIME_IN_MS
UNIX_TIME_FROM_TIME_IN_SECS

On Tue, Jun 7, 2016 at 5:23 AM, Till Westmann <tillw@apache.org> wrote:
> I think that it=E2=80=99s fine to add a function for this. However, AFAIK=
 the UNIX
> timestamp is in seconds [1], so it seems that we don=E2=80=99t need funct=
ions for
> different time units.
>
> Is there a reason why we should support different time units?
>
> Cheers,
> Till
>
> [1] https://en.wikipedia.org/wiki/Unix_time
>
> On 6 Jun 2016, at 3:08, Ian Maxon wrote:
>
>> I don't think so. The other way around (timestamp to datetime) only exis=
ted
>> until relatively recently. I never made the other way around, or at leas=
t I
>> don't recall doing it.
>>
>> On Sun, Jun 5, 2016 at 3:03 PM, Preston Carman <prestonc@apache.org> wro=
te:
>>
>>> Is there a way to get the Unix timestamp of a datetime value? The data
>>> is stored in this way. We have several functions to take a UNIX
>>> timestamp and create an AsterixDB datetime value, but do we have the
>>> other way around?
>>>
>>> Possible functions
>>> UNIX_TIME_FROM_DATETIME_IN_MS
>>> UNIX_TIME_FROM_DATETIME_IN_SECS
>>>
>>> Thoughts on adding these functions?
>>>
>>> Just wanted to check to see if I was missing the way method to get a
>>> Unix timestamp or it was actually missing.
>>>
>>> Thanks
>>> Preston
>>>