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()