A much simpler way to always display 2-byte days and months is: select convert(char(10),getdate(),101)   The 101 style will always give you mm/dd/yyyy