This function is a partial compatibility implementation of MS SQL Server's CONVERT function. It converts a date to a string using the specified style. This function is a partial compatibility ...

Isn't there an easy way to get a 2-digit day from a SQL query?SELECT datepart(dd, getDate()); will return "1" for July 1st. How can I get it to return "01";Best I can come up with is:select RIGHT ...