"cet" <cet@discussions.microsoft.com> wrote in message news:C8D0F541-6CD2-4044-8DEB-E8131F1E6FF5@microsoft.com...
> Hi,
>
> Currently when I perform a export to excel, those fields with datetime will
> only show date. I understand that I can open that excel file and change to
> the correct format. But I would like to have it set automatically after the
> export is done.
> How should I do so that it can show out the date and time?
> --
> Thanks

"Allan Mitchell" wrote:

> Not really sure that you can. If you click on the exported datetime cell you wil see in the fx bar that the value is the true value
> it is just the cell that renders it incorrectly
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "cet" <cet@discussions.microsoft.com> wrote in message news:C8D0F541-6CD2-4044-8DEB-E8131F1E6FF5@microsoft.com...
> > Hi,
> >
> > Currently when I perform a export to excel, those fields with datetime will
> > only show date. I understand that I can open that excel file and change to
> > the correct format. But I would like to have it set automatically after the
> > export is done.
> > How should I do so that it can show out the date and time?
> > --
> > Thanks
>
>