sql时间查询
sql中的时间查询2009-06-24 12:07查询本日的记录select * from tableName where DATEPART(dd, theDate) = DATEPART(dd, GETDATE()) and DATEPART(mm, theDate) = DATEPART(mm, GETDATE()) and DATEPART(yy, theDate) = DATEPART(yy, GETDATE()) 查询本月的记录select * from tableName where DATEP
原创
2010-12-12 09:36:00 ·
2557 阅读 ·
0 评论