/SQL/Sqlalchemy postgres timestamp with timezone

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())
    )

Source: stackoverflow.com

Timestamp with timezone postgres

foo=> SET TIMEZONE TO 'Japan';
SET
foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 00:00:00+09
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 06:00:00+09
(1 row)

foo=> SET TIMEZONE TO 'Australia/Melbourne';
SET
foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 00:00:00+11
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 08:00:00+11
(1 row)

Source: stackoverflow.com

Similar codes

9 votes176 views3 answers
Mysql run sql file
SQL
0 vote167 views1 answer
Version and edition of SQL Server Database Engine
SQL
4 votes171 views1 answer
Oracle show errors
SQL
19 votes163 views2 answers
Mysql add column after another
SQL
1 vote181 views1 answer
Select 2 rows in sql
SQL
0 vote169 views1 answer
Sqlite referential integrity
SQL
1 vote175 views2 answers
Insert sqlite
SQL
0 vote187 views1 answer
Oracle last connexion
SQL
1 vote130 views1 answer
Into sql
SQL
0 vote163 views1 answer
Add colum date in sql
SQL