Date transforms from dd/mm/yyyy to mm/dd/yyyy - why?

#1

Hi all,

I'm loading some tables via DTS with the input files being comma
delimited .txt files.

For 2 date fields (format =smalldatetime in sql) if I pass a value of:

"14/10/1980" it stores as 1980-10-14 which is correct.

But if I pass a value of:

"07/11/1980" it stores a value of 1980-07-11 when it should be
1980-11-07

Any ideas on this?

Thanks,
Sean

#2

Hello Sean,

The way I look at these types of problem is I look at the

Language of the user doing the execution in SQL Server Logins
The Language of the Server on which SQL Server is hosted

These two things matter with date translations. When i cannot resolve things
using this or I do not have time to do it I turn to this

http://www.sqldts.com/default.aspx?249

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hi all,

I'm loading some tables via DTS with the input files being comma
delimited .txt files.

For 2 date fields (format =smalldatetime in sql) if I pass a value of:

"14/10/1980" it stores as 1980-10-14 which is correct.

But if I pass a value of:

"07/11/1980" it stores a value of 1980-07-11 when it should be
1980-11-07

Any ideas on this?

Thanks,
Sean

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

Date transforms from dd/mm/yyyy to mm/dd/yyyy - why?

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

Date transforms from dd/mm/yyyy to mm/dd/yyyy - why? - 03-08-2006 , 02:55 PM

Re: Date transforms from dd/mm/yyyy to mm/dd/yyyy - why? - 03-09-2006 , 03:21 PM