Hi,

I have created a DTS to import a set of data from excel to SQL table. The
date format in excel is dd/mm/yyyy HH:mm tt. I want to change to date format
in SQL to mm/dd/yyyy. May I know how to change.

I tried to use the date time string transformation properties in dts but not
successful. The sql table is still showing the same date format as in the
excel file.

Can someone help.

Thank you very much

Tiffany

Are you using a datetime field If you are then it doesn't matter how you pass
it in it will always be stored the same
Do the formatting in the front-end
For formatting output in SQL read this
http://sqlservercode.blogspot.com/20...server_21.html



"Tiffany" wrote:

Hi,

I still could not make it. Currently my date format is in dd/MM/yyyy hh:mm
tt format. I want to change it to MM/dd/yyyy in my SQL table.

Is there a simple query I could run in the query analyser to solve the
problem.

Kindly help.

Thanks a lot!!

"Tiffany" wrote:

The presentation of dates has nothing to do with SQL Server. Internally
they are held in one format only. The presentation is all about the
client. In Query Analyser you can look to the CONVERT() function in BOL
to change the presentation style.


Allan

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