troubleshooting Question
sql date format
need to populate 2 date variables with a specific date format
can get the required results from a select statement but need to use the same syntax to 'set' the variable
also once the @startDate variable is populated need to populate the @endDate variable to add 1 year: Set @endDate = DATEADD(year, 1, @startDate
can you please help with this?
can get the required results from a select statement but need to use the same syntax to 'set' the variable
Declare @startDate DateTime
Declare @endDate Datetime
select CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] -- this gives the desired output of 2013-07-17 but cant get it to work when setting the variable: Set @startDate = CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] - Incorrect syntax near the keyword 'AS'
also once the @startDate variable is populated need to populate the @endDate variable to add 1 year: Set @endDate = DATEADD(year, 1, @startDate
can you please help with this?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 20 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.