convert a gregorian date in mm/dd/yyyy

hello,
I want to convert a gregorian date in mm/dd/yyyy format in MS SQL 2000.
:)Are you lookig to convert from one of the Gregorian calendars to the Julian calendar, or just present an existing DATETIME value in the format you specified? The conversion is an interesting problem, the presentation issue ought to be solved on the client rather than the server, although you can make yourself a LOT of trouble later on by just using:SELECT Convert(VARCHAR(30), GetDate(), 101)-PatPsqlsql