RE: Help with dates

2016-04-05 Thread Riesland, Zack
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

Re: Help with dates

2016-04-05 Thread James Taylor
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

Help with dates

2016-04-05 Thread Riesland, Zack
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