Fantastic.
Thanks James
From: James Taylor [mailto:jamestay...@apache.org]
Sent: Tuesday, April 05, 2016 10:10 AM
To: user
Subject: Re: Help with dates
Phoenix let's you cast a BIGINT directly to a DATE, like this:
CAST(1458132989477 as DATE)
or like this if your BIGINT is in a column value
Phoenix let's you cast a BIGINT directly to a DATE, like this:
CAST(1458132989477 as DATE)
or like this if your BIGINT is in a column value:
CAST(my_bigint as DATE)
Thanks,
James
On Tue, Apr 5, 2016 at 6:31 AM, Riesland, Zack
wrote:
> I have ms-based, 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