Returns value timestamp with time zone as SysTime Note that SysTime has a precision in hnsecs and PG TimeStamp in usecs. It means that PG value will have 10 times lower precision. And as both types are using long for internal storage it also means that PG TimeStamp can store greater range of values than SysTime.
Returns value data as native Date
Returns value time without time zone as native TimeOfDay
Returns value timestamp without time zone as TimeStamp
Returns value timestamp with time zone as TimeStampUTC
Returns value timestamp without time zone as DateTime (it drops the fracSecs from the database value)
PostgreSQL time types binary format.