Mailing-List: contact dev-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
From: "Till Westmann" <tillw@apache.org>
To: dev@asterixdb.apache.org
Subject: Re: Datetime to Unix Timestamp
Date: Tue, 07 Jun 2016 14:23:14 +0200
Message-ID: <D244F2FC-B1D4-46CB-AABD-121309867E92@apache.org>
In-Reply-To: <CAN_YF5xKSjuD+QnuA-WvCFyL5ehzVBELT7QT+zS413dEni350g@mail.gmail.com>
References: <CAA9eHv0uvELvP-C2cegvdXicYz76cQ74fSG9UGiiEvLay5JBvw@mail.gmail.com>
 <CAN_YF5xKSjuD+QnuA-WvCFyL5ehzVBELT7QT+zS413dEni350g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
archived-at: Tue, 07 Jun 2016 12:23:11 -0000

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
>>