troubleshooting Question

sql date format

Avatar of JCTDD
JCTDD asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
20 Comments1 Solution629 ViewsLast Modified:
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

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'

Open in new window

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?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 20 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros