timedelta days code example

Example 1: format time python

| Directive | Meaning                                                        | Example                 | 
|-----------|------------------------------------------------------------------------------------------|
|%a         | Abbreviated weekday name.                                      | Sun, Mon, ..            | 
|%A         | Full weekday name.                                             | Sunday, Monday, ...     | 
|%w         | Weekday as a decimal number.                                   | 0, 1, ..., 6            | 
|%d         | Day of the month as a zero-padded decimal.                     | 01, 02, ..., 31         | 
|%-d        | Day of the month as a decimal number.                          | 1, 2, ..., 30           | 
|%b         | Abbreviated month name.                                        | Jan, Feb, ..., Dec      | 
|%B         | Full month name.                                               | January, February, ...  | 
|%m         | Month as a zero-padded decimal number.                         | 01, 02, ..., 12         | 
|%-m        | Month as a decimal number.                                     | 1, 2, ..., 12           | 
|%y         | Year without century as a zero-padded decimal number.          | 00, 01, ..., 99         | 
|%-y        | Year without century as a decimal number.                      | 0, 1, ..., 99           | 
|%Y         | Year with century as a decimal number.                         | 2013, 2019 etc.         | 
|%H         | Hour (24-hour clock) as a zero-padded decimal number.          | 00, 01, ..., 23         | 
|%-H        | Hour (24-hour clock) as a decimal number.                      | 0, 1, ..., 23           | 
|%I         | Hour (12-hour clock) as a zero-padded decimal number.          | 01, 02, ..., 12         | 
|%-I        | Hour (12-hour clock) as a decimal number.                      | 1, 2, ... 12            | 
|%p         | Locale’s AM or PM.                                             | AM, PM                  | 
|%M         | Minute as a zero-padded decimal number.                        | 00, 01, ..., 59         | 
|%-M        | Minute as a decimal number.                                    | 0, 1, ..., 59           | 
|%S         | Second as a zero-padded decimal number.                        | 00, 01, ..., 59         | 
|%-S        | Second as a decimal number.                                    | 0, 1, ..., 59           | 
|%f         | Microsecond as a decimal number, zero-padded on the left.      | 000000 - 999999         | 
|%z         | UTC offset in the form +HHMM or -HHMM.                         |                         | 
|%Z         | Time zone name.                                                |                         | 
|%j         | Day of the year as a zero-padded decimal number.               | 001, 002, ..., 366      | 
|%-j        | Day of the year as a decimal number. 1, 2, ..., 366            |                         | 
|%U         | Week number of the year (Sunday as the first day of the week). | 00, 01, ..., 53         | 
|%W         | Week number of the year (Monday as the first day of the week). | 00, 01, ..., 53         | 
|%c         | Locale’s appropriate date and time representation.             | Mon Sep 30 07:06:05 2013|
|%x         | Locale’s appropriate date representation.                      | 09/30/13                | 
|%X         | Locale’s appropriate time representation.                      | 07:06:05                | 
|%%         | A literal '%' character.                                       | %                       |

Example 2: python date and time

from datetime import datetime
now = datetime.now()
print (now.strftime("%Y-%m-%d %H:%M:%S"))


Output: 2020-06-19 10:34:45

Example 3: datetime.strttime() syntax

from datetime import datetime

now = datetime.now() # current date and time

year = now.strftime("%Y")
print("year:", year)

month = now.strftime("%m")
print("month:", month)

day = now.strftime("%d")
print("day:", day)

time = now.strftime("%H:%M:%S")
print("time:", time)

date_time = now.strftime("%m/%d/%Y, %H:%M:%S")
print("date and time:",date_time)

Example 4: python datetime

from datetime import date
f_date = date(2014, 7, 2)
l_date = date(2014, 7, 11)
delta = l_date - f_date
print(delta.days)

Example 5: convert timedelta to days

# Convert TimeDelta column (5 days etc.) into an integer column (5)
import numpy as np
df.timeDelta = (df.timeDelta / np.timedelta64(1,'D')).astype(int)

Example 6: python timedelta get days with fraction

from datetime import timedelta

def get_days_between(datePast, dateFuture):
   difference = dateFuture - datePast
   return difference.total_seconds() / timedelta(days=1).total_seconds()