Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Select Right('00' + Convert(VarChar(2), Day(GetDate())), 2)
In T-SQL I would use CAST instead of CONVERT
Declare @DateToTest DateTime
Set @DateToTest = '20081225'
select @DateToTest, Day(@DateToTest), SUBSTRING('0' + CAST(DAY(@DateToTest) AS varchar(2)), 1, 2)
maybe y'all missed this the first time around