Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
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.
|I need to "lookback" and pull all data from 5pm and prior based on a date time field. Is there a getdatetime funcion?||4||28|
|Cannot get group page break to work in SSRS 2008R2.||14||38|
|T-SQL: Wrong Result||7||38|
|How to build a logic for passwords according to initials?||13||45|
Join the community of 500,000 technology professionals and ask your questions.