"logdate" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(),
表结构字段如上
表中数据"2008-2-26 14:50:13"这样的格式
我现在想查 26号到27号的数据select * from logs l where ((l.logdate > 2008-02-26) and (l.logdate < 2008-02-27))查询不出查,高手指点一下,谢谢!
表结构字段如上
表中数据"2008-2-26 14:50:13"这样的格式
我现在想查 26号到27号的数据select * from logs l where ((l.logdate > 2008-02-26) and (l.logdate < 2008-02-27))查询不出查,高手指点一下,谢谢!
where ((l.logdate >= '2008-02-26') and (l.logdate <= '2008-02-27'))
where l.logdate between '2008-02-26' and '2008-02-27'