Export dates to CSV

A table has a datetime column, which contains dates only (no time part). In
EM, the dates look like 5/10/2007. After exporting the table to a CSV file
using All Tasks->Export Data... the dates look like 2007-05-10 00:00:00.
How can I export the dates in the same format they appear in the EM, that is
5/10/2007? At least I need that the dates appear in the CSV file without the
time part.
Thank you.
Check BOL for the CONVERT function. I believe 101 is the one you are
looking for.
TheSQLGuru
President
Indicium Resources, Inc.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%2307zUA0kHHA.3264@.TK2MSFTNGP04.phx.gbl...
>A table has a datetime column, which contains dates only (no time part). In
>EM, the dates look like 5/10/2007. After exporting the table to a CSV file
>using All Tasks->Export Data... the dates look like 2007-05-10 00:00:00.
> How can I export the dates in the same format they appear in the EM, that
> is 5/10/2007? At least I need that the dates appear in the CSV file
> without the time part.
> Thank you.
>
>