Conversion between timestamp and timestamptz
Hi,
I have a table A with a timestamp field ( timestamp) and a table B with timestamp timezone ( timestamptz) , i am performing a join between them both and see a difference of 4 hours. i was wondering if there is a way to explicitly convert the timestamp field to timestamptx so that my join is accurate.
0
Comments
Maybe convert the TIMESTAMP to the TIME ZONE in question?
Example: