Internal format for TimeTZ
I have to handle TimeTZ in UDx c++. Normally I do not allow TimeTZ in tables, but user managed to create new table with TimeTZ datatype and it was too late when I caught it.
After few experiments, I found that TimeTZ in Vertica has number of micros since UTC midnight in top 5 bytes of 8-byte value.
Out of curiosity, what lower 3 bytes of TimeTZ contains? Looking at Postgress code, it should be number of seconds since epoch, but PgSQL TimeTZ is 12 bytes vs Vertica 8 bytes.
Looks like Vertica original developers invented something new for content of lower 3 bytes in TimeTZ.
Would you mind to ask around and share?
Thanks in advance