This is a simple query that give us Time and Date seperatly from Date Type in MS SQL 2000.
Select P.Code, Convert(Varchar,P.ArrivalTime,1) as Product_Date, Convert(Varchar,P.ArrivalTime,8) as Product_Time from Product P.
If you Change 1 and 8 in the Convert function you get new formates. I Know that its very simple .