My co-worker wrote the stored procedures which are
date as m/d/yyyy. Is there an easy SQL method he can use
stored procedure to pad the month and day with a leading
needed? We want mm/dd/yyyy.
It's kind of obscure in the BOL -- took me a minute to find it too...