django - filter( create_at)

BackEnd_Ash.log·2020년 6월 29일
0

datetime

datetime.now().year
# 2020
datetime.now().month
# 6

filter


Models.objects.filter(create_at__year__lte  = year , 
		     create_at__month__lte = month).count()
# 16

dateutil.relativedelta

from datetime import datetime
import dateutil.relativedelta

now = datetime.now()
year = datetime.now().year
month = datetime.now().month
now_day = now.strftime("%Y%m")  # 202006

today = str(now + dateutil.relativedelta.relativedelta(months=0)).split()[0].replace("-", "")[:6]
previous_day = str(now + dateutil.relativedelta.relativedelta(months=-1)).split()[0].replace("-", "")[:6]
next_day = str(now + dateutil.relativedelta.relativedelta(months=+1)).split()[0].replace("-", "")[:6]
previous_day2 = str(now + dateutil.relativedelta.relativedelta(months=-7)).split()[0].replace("-", "")[:6]
print(today)
print(previous_day)  # 20200526
print(next_day)
print(previous_day2)

filter datetime.date

import datetime

samples = Models.
	  objects.
	  filter(sampledate__gte = datetime.date(2020,6,1),
	  	 sampledate__lte = datetime.date(2020,6,29))

timedelta

 startdate  = date.today()
    enddate = startdate + timedelta(days=6)
    Sample.objects.filter(date__range=[startdate, enddate])
profile
꾸준함이란 ... ?

0개의 댓글