timestamp with timezone postgres code example

Example 1: postgres set timezone

SET TIME ZONE 'Europe/Moscow';

Example 2: storing timezones in postgres

select name from pg_timezone_names where name not like 'posix%' and name not ilike 'system%' order by name;

Example 3: postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';

Example 4: sqlalchemy postgres timestamp with timezone

from sqlalchemy import Column, DateTime, Integer, MetaData, Table
from sqlalchemy.sql import func

metadata = MetaData()

example = Table('example', metadata,
    Column('id', Integer, primary_key=True),
    Column('date', DateTime(timezone=True), default=func.now())
    )

Tags:

Misc Example

Related