5.39. Date and Time Frequency

Table 5.20. Offset aliases

Alias

Description

B

business day frequency

C

custom business day frequency

D

calendar day frequency

W

weekly frequency

M

month end frequency

SM

semi-month end frequency (15th and end of month)

BM

business month end frequency

CBM

custom business month end frequency

MS

month start frequency

SMS

semi-month start frequency (1st and 15th)

BMS

business month start frequency

CBMS

custom business month start frequency

Q

quarter end frequency

BQ

business quarter end frequency

QS

quarter start frequency

BQS

business quarter start frequency

A, Y

year end frequency

BA, BY

business year end frequency

AS, YS

year start frequency

BAS, BYS

business year start frequency

BH

business hour frequency

H

hourly frequency

T, min

minutely frequency

S

secondly frequency

L, ms

milliseconds

U, us

microseconds

N

nanoseconds

Table 5.21. Date frequency units

Frequency

Letter

Long name

Short name

Year

Y

Month

M

Week

W

Day

D

day, days

Hour

H

hour, hours

h, hr

Minute

T

minute, minutes

m, min

Second

S

second, seconds

sec

Millisecond

L

millisecond, milliseconds

ms, milli, millis

Microsecond

U

microsecond, microseconds

us, micro, micros

Nanosecond

N

nanosecond, nanoseconds

ns, nano, nanos