摘要:SELECT CONVERT(VARCHAR(7),DATEADD(MONTH,number,'2016-01-01'),120) FROM master..spt_values WHERE type='P' AND DATEADD(MONTH,number,'2016-01-01')<='2017
阅读全文
posted @ 2016-05-27 16:31
|
||
05 2016 档案
摘要:SELECT CONVERT(VARCHAR(7),DATEADD(MONTH,number,'2016-01-01'),120) FROM master..spt_values WHERE type='P' AND DATEADD(MONTH,number,'2016-01-01')<='2017
阅读全文
posted @ 2016-05-27 16:31
摘要:select convert(varchar(10),dateadd(dd,number,convert(varchar(8),getdate(),120)+'01'),120) as dt from master..spt_values where type='P' and dateadd(dd,number,convert(varchar(8),getdate(),120)+'01')<...
阅读全文
posted @ 2016-05-20 09:59
|
||