phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Riesland, Zack" <Zack.Riesl...@sensus.com>
Subject Help with dates
Date Tue, 05 Apr 2016 13:31:02 GMT
I have ms-based, GMT timestamps in BigInt columns in one of my phoenix tables.

It's easy to work with these in Java, but I'm struggling to find the right syntax to easily
read them in a simple query.

For example: '1458132989477'

I know this is Wed, 16 Mar 2016 12:56:29.477 GMT

But when I do something like this:

to_char(to_date('1458132989477', 'S'), 'yyyy-MM-dd')


I get 1970-01-25

I looked at the functions page of the Phoenix website: https://phoenix.apache.org/language/functions.html

Can someone help me figure out what I'm missing? Is there an official list of arguments for
to_date()?

Thanks!

Mime
View raw message