mburk1968
asked on
SQL Convert to DateTime
How do I convert the STDStartDate & STDEndDate to a datetime value to pass into my query versus text?
SELECT DATEADD(wk, 0,
DATEADD(DAY, 1 - DATEPART(WEEKDAY, GETDATE()),
DATEDIFF(dd, 0, GETDATE()))) AS WkStartDate ,
DATEADD(wk, 1,
DATEADD(DAY, 0 - DATEPART(WEEKDAY, GETDATE()),
DATEDIFF(dd, 0, GETDATE()))) AS WkEndDate ,
DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) AS MthStartDate ,
DATEADD(dd, -1, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 0)) AS MthEndDate ,
DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS YearStartDate ,
DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, -1) AS YearEndDate,
[b]CASE WHEN GETDATE() <= '2016-06-30' THEN '2016-01-01' ELSE '2016-07-01' END AS STDStartDate,
CASE WHEN GETDATE() <= '2016-06-30' THEN '2016-06-30' ELSE '2016-12-31' END AS STDEndDate;
[/b]
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER