How to create the first day of the month in given below query using sql server.

Hi,

Please refer below code.

SQL

DECLARE @Input DATETIME
SET @Input = '2016-04-26'
 
DECLARE @Output DATETIME
SET @Output = DATEADD(DAY,-DAY(DATEADD(MONTH,0,DATEADD(MONTH,-12,@Input)))+1,DATEADD(MONTH,-12,@Input))
 
SELECT @Input As Input
SELECT @Output AS [Output]

Output

Input

2016-04-28 00:00:00.000

Output

2015-04-01 00:00:00.000