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