asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Till Westmann" <ti...@apache.org>
Subject Re: Datetime to Unix Timestamp
Date Tue, 07 Jun 2016 12:23:14 GMT
I think that it’s fine to add a function for this. However, AFAIK the UNIX
timestamp is in seconds [1], so it seems that we don’t need functions 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 existed
> until relatively recently. I never made the other way around, or at least I
> don't recall doing it.
>
> On Sun, Jun 5, 2016 at 3:03 PM, Preston Carman <prestonc@apache.org> wrote:
>
>> 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
>>

Mime
View raw message