To show date and time for field type of datetime during export to

#1

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

#2

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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

#3

In the fx bar, it is showing the correct format. But the cell is only showing
date.
Then may I post the question as - what to configure so that the cell in
excel will automatically show out the date and time?

"Allan Mitchell" wrote:

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

To show date and time for field type of datetime during export to

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

To show date and time for field type of datetime during export to - 03-28-2005 , 08:27 AM

Re: To show date and time for field type of datetime during export to - 03-29-2005 , 02:11 PM

Re: To show date and time for field type of datetime during export - 03-30-2005 , 10:07 AM