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语句(日期时间) |