user: public
login

SQL Tid Bits

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)

size: 375 bytes    file modified: 2019.4.2