SQL Server Forums - mm/dd/yyyy format - SQL Server Information at SQLTeam.com

Because that's where all formatting and presenation of the data returned from SQL should be done. You should just about never do any sort of formatting in T-SQL -- it is simply not designed for that. As soon as you format a date as "mm/dd/yyyy" or money v

www.sqlteam.com