SELECT YEAR(GETDATE()) AS [YEAR], MONTH(GETDATE()) AS [MONTH], DAY(GETDATE()) AS [DAY], CONVERT(VARCHAR(10),GETDATE(),120) AS TODAY /* YEAR MONTH DAY TODAY ----------- ----------- ----------- ---------- 2008 11 19 2008-11-19 */
year month day getdate()selcet * from tblworkprocess where inserttime>=(select getdate())真是奇怪的语句,居然要求出大于当前时间的记录,有这种数据吗?
selcet * from tblworkprocess where inserttime>=CONVERT(VARCHAR(10),GETDATE(),120)日期格式为:2008-11-19
selcet * from tblworkprocess where datediff(day,inserttime,getdate())>=0
MONTH(GETDATE()) AS [MONTH],
DAY(GETDATE()) AS [DAY],
CONVERT(VARCHAR(10),GETDATE(),120) AS TODAY
/*
YEAR MONTH DAY TODAY
----------- ----------- ----------- ----------
2008 11 19 2008-11-19
*/
getdate()selcet * from tblworkprocess where inserttime>=(select getdate())真是奇怪的语句,居然要求出大于当前时间的记录,有这种数据吗?
selcet * from tblworkprocess where datediff(day,inserttime,getdate())>=0