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?