Timestamp wit time zone conversio

Database
Enthusiast

Timestamp wit time zone conversio

Hi,

 I have a table with timestamp(3) column. Timestamp value is normalized to UTC 0 time zone.

I want to query that table using local time for Brasil, but I want to avoid normalizing UTC 0 time zone to brasilian.

example:

tablax.timestampcolumn (at UTC 0) >  (local time in Brasil) that is converted to UTC 0

Can someone help, I know the answer is simple but I am just starting with TD.

Thanks,

Piotr

1 REPLY
Enthusiast

Re: Timestamp wit time zone conversio

I think if you select the Timestamp column without normalizing, It will result according to your local Brazil time. Have you tried it?

Khurram