Toad World® Forums

Toad display date columns in UTC. How can I see them in my local time zone?


#1

I’m using version 9.7.2.5. We have certain date columns (type = date) that have UTC dates populated. In the sql window, Toad is display those dates “as is” (utc), but I wonder if there’s a setting to display the dates in my local time zone. I’m 9 hours away from Greenwich, so it’s a pain to find my rows based on the datetime they were created.

I don’t want to use a convert function in my select statement, I’d like to run “select * from table” and see all dates in my local time zone,

Any suggestions?