I am grabbing few fields from a table and one of the columns is in date format. The output which I am getting is "Wed Feb 09 00:00:00 2005" but the data in that column is "02/09/2005" and I need the same format output to insert those recodes into another table. print my_service_DATE Wed Feb 09 00:00:00 2005 Any help is highly appreciated. sk