Export dates to CSV

10 May 2007 8:16 PM

Vik

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.

11 May 2007 2:45 AM

TheSQLGuru

Check BOL for the CONVERT function. I believe 101 is the one you are
looking for.

--
TheSQLGuru
President
Indicium Resources, Inc.

Show quote

"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.
>
>
>