convert(nvarchar(16),getdate(),120) => 2019-04-26 11:56
–DATEPART(month,CreateDate)...)
select convert(char(10),dateadd(dd, - DATEPART (weekday , getdate()+@@DATEFIRST -1)-14,getdate()),120...-2-6'
set @end='2015-12-2'
declare @months int
set @months=DATEDIFF(month,@begin,@end)
select convert...= ISNULL(@sql2 + ',', '') + '['+convert(varchar(100), duty_date, 112)+']' FROM (
SELECT convert(varchar...(VARCHAR(10),GETDATE(),120) –2015-07-13
SELECT CONVERT(VARCHAR(10),GETDATE(),101) –07/13/2015
–按日分组