Timezone in python


import pytm, datetime


Print all time zone with the help of pytm

pytz.all_timezones

or 

for tz in pytz.all_timezones:

 print (tz)

UTC Date Time
date_time_utc = datetime.datetime.utcnow()

Create timezone object
america_st_johns = pytz.timezone('America/St_Johns')

Convert UTC to other TimeZone
local_dt = date_time_utc.replace(tzinfo=pytz.utc).astimezone(america_st_johns)
Output # datetime.datetime(2019, 8, 20, 13, 49, 18, 905051, tzinfo=<DstTzInfo 'America/St_Johns' NDT-1 day, 21:30:00 DST>)


Remove tzinfo from this object

date_time.replace(tzinfo = None)
Output # datetime.datetime(2019, 8, 20, 13, 51, 38, 177591)






Comments

Post a Comment

Popular posts from this blog

SQLAlchemy Create Table and Insert Data

Image
 # SQLAlchemy-1.3.20 # pip install pymysql from sqlalchemy import (create_engine, MetaData, Table, Column, Integer, String, DateTime) from datetime import datetime meta_data = MetaData() # db_connection = 'mysql+pymysql://username:pasword@hostname/db_name'  db_connection = 'mysql+pymysql://root:india@123@localhost/sql_alchemy' #table = Model users = Table('users', meta_data, Column('user_id', Integer(), primary_key = True), Column('username', String(15), nullable = False, unique = True), Column('email', String(150), nullable = False), Column('password', String(12), nullable = False), Column('created_on', DateTime(),default=datetime.now,nullable = False), Column('update_on', DateTime(), default=datetime.now, onupdate=datetime.now,nullable = False) ) engine = create_engine(db_connection) try:   conn = engine.connect()   print('db connected')   print('connection object is ...
Read more

SQLAlchemy ForeignKey Constraints

Image
       # SQLAlchemy-1.3.20 # pip install pymysql from sqlalchemy import (create_engine, Float, Text, MetaData,  Table, Column, Integer, String, DateTime, ForeignKey) from datetime import datetime meta_data = MetaData() db_connection = 'mysql+pymysql://root:india@123@localhost/sql_alchemy' # db_connection = 'mysql+pymysql://username:pasword@localhost/db_name' #table = Model users = Table('users', meta_data, Column('user_id', Integer(), primary_key = True), Column('username', String(15), nullable = False, unique = True), Column('email', String(150), nullable = False), Column('password', String(12), nullable = False), Column('created_on', DateTime(),default=datetime.now,nullable = False), Column('update_on', DateTime(), default=datetime.now, onupdate=datetime.now,nullable = False) ) dish_items = Table('dish_items', meta_data, Column('di...
Read more