34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT CAST(CONVERT(VARCHAR(7),'2009-12-25 14:20:00',120)+'-01' AS DATETIME)
/**
------------------------------------------------------
2009-12-01 00:00:00.000
(所影响的行数为 1 行)
**/
if exists(select 1 from tb where YEAR(DATE)=2009 AND MONTH(DATE)=12 AND status=1)
SELECT A,B,C,DATE FROM table WHERE YEAR(DATE)=2009 AND MONTH(DATE)=12
else
SELECT top 1 A,B,C,DATE FROM table WHERE date<'2009-12-01' order by date dese