sqlite时间函数及时间日期处理
('2006-10-17','+1 day','+1 year');结果:2007-10-18例5.获取本年年初零点(零刻)select datetime('now','start of year');结果:2006-01-01 00:00:00例6.获取本月月初零点(零刻)select datetime('now','start of month');结果:2006-10-01 00:00:00例7.获取当天零点(零刻)select datetime('now','start of day');结果:2006-10-17 00:00:00例8.select datetime('now','