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!
