How to return current date in a different timezone in PostgreSQL

select current_date at time zone 'UTC',current_date::timestamp ; or any other zone

enter image description here

update:

select (current_date at time zone 'UTC')::date,current_date::date

enter image description here

SELECT date(timezone('EST', now()))

will return the current date in Eastern Standard Time regardless of database time zone

(or any other time zone, will however NOT work with offsets, for whatever reason...)

SELECT date(timezone('UTC±XX', now()::timestamp))

if you want to use offsets, this will only work with UTC offsets though...

Related