select
dayofweek(create_datetime),
create_datetime,
2 as time_type
from
数据结果: 1 周日 2周一…6周日
python 一周只能3次 一月最多7次 一年最多15次
now = datetime.now()
week_start_time = (now - timedelta(days=now.weekday())).strftime('%Y-%m-%d 00:00:00')
yue_start_time = now.strftime('%Y-%m-1 00:00:00')
year_start_time = now.strftime('%Y-1-1 00:00:00')
end_time = now.strftime('%Y-%m-%d %H:%M:%S')
查询结果集在其中的有多少(上面为时间字符串 还需转化为时间格式)