Re: Differences between the date/time types

2017-03-17 Thread James Taylor
The DATE and TIME types in Phoenix are more or less the same. They store their data as an 8 byte long Epoch time and maintain millisecond granularity. The TIMESTAMP stores nanosecond data in a 12 bytes - an 8 byte long Epoch time plus 4 bytes for nanoseconds. Unless you need nanosecond

Re: Differences between the date/time types

2017-03-17 Thread Cheyenne Forbes
Anyone?

Differences between the date/time types

2017-02-15 Thread Cheyenne Forbes
I cant find the difference between the date/time types, arent all of them the same? also should I parse them as int or string? TIME Type TIME The time data type. The format is -MM-dd hh:mm:ss, with both the date and time parts maintained. Mapped to java.sql.Time. The binary representation is