We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Declare @EndDate as varchar(12) declare @month as varchar(2) declare @year as varchar(4) Set @EndDate = @startdate > should be '03/01/2015' (the first day of next month) Set @Month = @startdate > should be '02' Set @Year = @startdate > should be '2015' select @enddate select @month select @year select MONTH('02/01/2015') < how can I return '02' instead of '2' select YEAR('02/01/2015') < this is ok '2015'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.