Skip to content

Tag: timezone

How to get all data post midnight of different timezone?

I have a PostgreSQL table named testing with a column named creation_time as timestamp with time zone. The database timezone is UTC Now I want to get all rows whose time is greater than 00:00 of the current day as per the timezone “America/New_York”. I know how to get all rows after local midnight: But how to use this query

CONVERT_TZ() equivalent in Oracle

I am trying to convert a timestamp value of the format YYYY-MM-DDTHH24:MI:SS to another timezone value YYYY-MM-DD HH24:MI:SS.SSSSSS. I was able to do this in MySql using the CONVERT_TZ(date, from_tz, …