user: public

SQL Tid Bits


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...


size: 375 bytes    file modified: 2019.4.2