sqlite时间函数及时间日期处理
,'+1 hour','-12 minute');结果:2006-10-17 01:08:00例4.获取明年的明天select date('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('n