How do I extract a query result of 08/27/1998 from a field of 1998-08-27 00:00:00.000 in SQL Server 2000
Posted on 2005-04-22
I am using a DTS package to export data to a CSV file. Everything is perfect in the output file, however the vendor requesting the file needs the Date field to be in the mm/dd/yyyy format.
The field in the SQL2000 database is in the 1998-08-27 00:00:00.000 format.
I have tried the string functions, but they will not work on a datetime field.
What do I have to add to the query to extract the field in the correct format.
Thanks in advance.