Actually, it looks as though you will want to use format mask 101, not 103. I am presuming the date is April 1, 2002 and you want it in MM/DD/YYYY format. You do this by using the CONVERT function with a format mask (you can view the various format masks using the online T-SQL reference from Query Analyzer).
Originally posted by WingMan You can use the convert function to change the output format of of dates.
I.E Select convert(varchar(10),<MYDATE>,103)
Convert converts the output for this column
Varchar(10) is the format this will be converted to
103 is the Standard British date format for SQL Server