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 <[email protected]> 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 >>
