Internal format for TimeTZ

Sergey_Cherepan_1

Hi,

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
Sergey

SergeB

I think the lower 24 bits represent the timezone as UTC offset in seconds.

Sergey_Cherepan_1

Thanks! That makes sense.