摘要:
sql如何取某年某月的第一天和最后一天SELECT CAST((LEFT('20093',4)+'-'+SUBSTRING('20093',5,LEN('20093'))+'-'+'01') AS DATETIME)--第一天SELECT DATEADD(DAY,-1,DATEADD(MONTH,1,CAST((LEFT('20093',4)+'-'+SUBSTRING('20093',5,LEN('20093'))+'- 阅读全文
posted @ 2011-09-14 10:34
开始测试
阅读(1352)
评论(0)
推荐(0)
浙公网安备 33010602011771号