sqllite/时间函数
来源：互联网 发布：log4j不打印sql语句 编辑：程序博客网 时间：2024/06/16 18:34
例1.select datetime('now');结果：2006-10-17 12:55:54例2.select datetime('2006-10-17');结果：2006-10-17 12:00:00例3.select datetime('2006-10-17 00:20:00','+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('now','start of day');结果：2006-10-17 00:00:00例8.select datetime('now','+10 hour','start of day','+10 hour');结果：2006-10-17 10:00:00例9.select datetime('now','localtime');结果：2006-10-17 21:21:47例10.select datetime('now','+8 hour');结果：2006-10-17 21:24:45
