Hi All
We have a DTS package which exports query results to a
text file. The query is dynamic and can contain some or
all fields in the table. I define the source/destination
columns by looping through the system table and reading
the column name etc. The problem is the date fields are
coming across as YYYY-MM-DD HH:MM:SS and I need it to be
mm/dd/yyyy. How can I force the formatting.
Any help would be appreciated.
Thanks
Dave

You could try CASTing

Look up CAST in BOL.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"dcd" <anonymous (AT) discussions (DOT) microsoft.com> wrote