返回列表 发帖

dateutil.rrule()函数

Windows安装第三方库:(python-dateutil)
C:\Users\jacky\Desktop>pip3 install python-dateutil -i http://mirrors.aliyun.com/pypi/simple --trusted-host=mirrors.aliyun.com



######
例子一:
查询两个日期之间的相隔天数:( 不足一天的话,返回的结果会是0 )
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2019-7-12'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Days = rrule.rrule(rrule.DAILY, dtstart = date1, until = date2).count()
Days = Days - 1
print(Days)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-07-12
0

C:\Users\jacky\Desktop>



######
例子二:
查询两个日期之间的相隔天数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2019-07-15'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Days = rrule.rrule(rrule.DAILY, dtstart = date1, until = date2).count()
Days = Days - 1
print(Days)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-07-15
3

C:\Users\jacky\Desktop>



######
例子三:
查询两个日期之间的相隔天数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-15'
d2 = '2019-08-15'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Days = rrule.rrule(rrule.DAILY, dtstart = date1, until = date2).count()
Days = Days - 1
print(Days)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-15
2019-08-15
31

C:\Users\jacky\Desktop>



######
例子四:
查询两个日期之间的相隔天数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-15'
d2 = '2020-08-15'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Days = rrule.rrule(rrule.DAILY, dtstart = date1, until = date2).count()
Days = Days - 1
print(Days)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-15
2020-08-15
397

C:\Users\jacky\Desktop>





######
例子五:
查询两个日期之间的相隔月数:( 不足一个月的话,返回的结果会是0 )
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2019-08-8'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Months = rrule.rrule(rrule.MONTHLY, dtstart = date1, until = date2).count()
Months = Months - 1
print(Months)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-08-08
0

C:\Users\jacky\Desktop>



######
例子六:
查询两个日期之间的相隔月数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2019-10-08'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Months = rrule.rrule(rrule.MONTHLY, dtstart = date1, until = date2).count()
Months = Months - 1
print(Months)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-10-08
2

C:\Users\jacky\Desktop>



######
例子七:
查询两个日期之间的相隔月数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2019-10-12'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Months = rrule.rrule(rrule.MONTHLY, dtstart = date1, until = date2).count()
Months = Months - 1
print(Months)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-10-12
3

C:\Users\jacky\Desktop>



######
例子八:
查询两个日期之间的相隔月数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2019-10-13'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Months = rrule.rrule(rrule.MONTHLY, dtstart = date1, until = date2).count()
Months = Months - 1
print(Months)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-10-13
3

C:\Users\jacky\Desktop>



######
例子九:
查询两个日期之间的相隔月数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2018-02-08'
d2 = '2019-03-06'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Months = rrule.rrule(rrule.MONTHLY, dtstart = date1, until = date2).count()
Months = Months - 1
print(Months)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2018-02-08
2019-03-06
12

C:\Users\jacky\Desktop>



######
例子十:
查询两个日期之间的相隔月数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2018-02-08'
d2 = '2019-03-08'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Months = rrule.rrule(rrule.MONTHLY, dtstart = date1, until = date2).count()
Months = Months - 1
print(Months)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2018-02-08
2019-03-08
13

C:\Users\jacky\Desktop>





######
例子十一:
查询两个日期之间的相隔年数:( 不足一年的话,返回的结果会是0 )
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-7-12'
d2 = '2019-11-20'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Years = rrule.rrule(rrule.YEARLY, dtstart = date1, until = date2).count()
Years = Years - 1
print(Years)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2019-11-20
0

C:\Users\jacky\Desktop>



######
例子十二:
查询两个日期之间的相隔年数:( 不足一年的话,返回的结果会是0 )
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2020-07-11'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Years = rrule.rrule(rrule.YEARLY, dtstart = date1, until = date2).count()
Years = Years - 1
print(Years)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2020-07-11
0

C:\Users\jacky\Desktop>



######
例子十三:
查询两个日期之间的相隔年数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2020-07-12'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Years = rrule.rrule(rrule.YEARLY, dtstart = date1, until = date2).count()
Years = Years - 1
print(Years)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2020-07-12
1

C:\Users\jacky\Desktop>



######
例子十四:
查询两个日期之间的相隔年数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2019-07-12'
d2 = '2020-07-13'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Years = rrule.rrule(rrule.YEARLY, dtstart = date1, until = date2).count()
Years = Years - 1
print(Years)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2019-07-12
2020-07-13
1

C:\Users\jacky\Desktop>



######
例子十五:
查询两个日期之间的相隔年数:
#coding=utf-8
import datetime as dt
from dateutil import rrule

d1 = '2000-06-16'
d2 = '2018-04-09'

date1 = dt.datetime.strptime(d1, "%Y-%m-%d").date()
date2 = dt.datetime.strptime(d2, "%Y-%m-%d").date()

print(date1)
print(date2)

Years = rrule.rrule(rrule.YEARLY, dtstart = date1, until = date2).count()
Years = Years - 1
print(Years)


脚本运行的结果:
C:\Users\jacky\Desktop>python xx.py
2000-06-16
2018-04-09
17

C:\Users\jacky\Desktop>





######
Windows卸载第三方库:(python-dateutil)
C:\Users\jacky\Desktop>pip3 uninstall python-dateutil -y
Uninstalling python-dateutil-2.8.2:
  Successfully uninstalled python-dateutil-2.8.2

C:\Users\jacky\Desktop>





相关文章:
datetime模块
MSSQL的SQL语句(日期时间)

返回列表