Datetime formats To convert column foo, which is of type datetime, to mm-dd-yyy format: convert(char(10),foo,110) '110' specifies the 'style' to use. A few styles of interest: 101: mm/dd/yyyy 102: yyyy.mm.dd 110: mm-dd-yyyy 111: yyyy-mm-dd 108: hh:mm:ss 112: yyyymmdd