select-datetime-timezone.md

select date timezone

• assuming datetime stored without time zone ( ie. UTC )

• to retrieve datetime as local 'Europe/Rome'

select ((document_date at time zone 'UTC') at time zone 'Europe/Rome') from document