Calculate tow date difference in python


from datetime import datetime, time

def date_diff_in_seconds(date2, date1):
  timedelta = date2 - date1
  return timedelta.days * 24 * 3600 + timedelta.seconds

def calculate_seconds(seconds):
minutes, seconds = divmod(seconds, 60)
hours, minutes = divmod(minutes, 60)
days, hours = divmod(hours, 24)
return (days, hours, minutes, seconds)

#Specified date
first_date = datetime.strptime('2019-07-19 01:00:00', '%Y-%m-%d %H:%M:%S')

#Current date
second_date = datetime.now()

print("\n%d day(s), %d hour(s), %d minute(s), %d second(s)" % calculate_seconds(date_diff_in_seconds(second_date, first_date)))

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