If we want to use a query in SQL Server 2000 to format a column dt1 with datetime data type to something like 2006/11/14, and to format a column money1 with money data type to something like 12,345.67, then part of the Select statement will be like:

Select Convert( Varchar, dt1, 111) as myDateTime, Convert( Varchar, Convert(money, money1), 1) as myMoney.....