/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

1 vote348 views1 answer
Mysql size int
SQL
0 vote355 views1 answer
Sql column contains special character
SQL
3 votes343 views2 answers
Mysql user permission database
SQL
0 vote372 views1 answer
How to pass list as parameter in SQL query
SQL
3 votes338 views2 answers
Mysql create timestamp column
SQL
0 vote439 views1 answer
Compare strings lexicographically in sql
SQL
0 vote346 views1 answer
C# mysql update statement set value to null
SQL
1 vote314 views3 answers
Remove unique key from a table
SQL
0 vote332 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote321 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL