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
Anyone?
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