/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

2 votes226 views1 answer
Mariadb select multiple rows into one column
SQL
2 votes257 views1 answer
Merge two columns in sql oracle
SQL
11 votes206 views2 answers
Oracle saurce code
SQL
2 votes199 views1 answer
Oracle list grants on procedure
SQL
3 votes194 views3 answers
How to add month in update sql
SQL
7 votes196 views3 answers
Sql set
SQL
0 vote217 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
8 votes255 views2 answers
Python simple connect to mysql
SQL
0 vote190 views1 answer
Mysql search like but first exact match
SQL
0 vote197 views1 answer
How to get specific salary in sql
SQL