How to use Date Time in python

# Import datetime module
import datetime
from datetime import timedelta, datetime

Today Date
print((datetime.now()).replace(hour=0, minute=0, second=0, microsecond=0)) print(datetime.today())
date = datetime.today()

print(date)
print(date.day)
print(date.year)
print(date.month)
print(date.hour)
print(date.minute)
print(date.second)
print(date.microsecond)

Create Static Date time object
datetime(2011, 07,07)

Python date object to Date str
print(datetime.today().strftime('%Y-%m-%d %H:%M:%S') )
print(datetime.today().strftime('%Y-%m-%d'))

Python date string to date object
print( datetime.strptime('20/02/2018','%d/%m/%Y') )
print(datetime.strptime('20/02/2018','%d/%m/%Y'))

Add Date and time in Date object
to_date = datetime.today() + timedelta(days=1, hours=5, minutes=30)
datetime.now().strftime('%Y%m%d%H%M%S')

change timespan to time
#timespan totsec = 14356
h = totsec//3600
m = (totsec%3600) // 60
sec =(totsec%3600)%60 #just for reference
print "%d:%d" %(h,m)

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
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)
Read more