Date Formats

[Nick]

Hi,

I'm entering a date into an SQL server using an Infragistics control. The
control picks the date format up from the system setting (UK). When the date
is entered into the database, it thinks its in US format and switches the
month & day.

In the stored procedure thats storing the data I have 'SET DATEFORMAT dmy'
which I though was supposed to tell SQL that incoming dates are in the
format specified, rather than the default mdy.

Can anyone help?

Thanks

[Vadivel Kumar]

Did you checked up by changing your
machine date format (Regional Settings)
to UK type?

Vadivel Kumar
http:\\charpblogs.blogspot.com

"Nick" <Ni**@NTWorks.no.spam.fsnet.co.uk> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Hi,

I'm entering a date into an SQL server using an Infragistics control. The
control picks the date format up from the system setting (UK). When the
date is entered into the database, it thinks its in US format and switches
the month & day.

In the stored procedure thats storing the data I have 'SET DATEFORMAT dmy'
which I though was supposed to tell SQL that incoming dates are in the
format specified, rather than the default mdy.

Can anyone help?

Thanks

[Nick]

Yes - All the PC settings are UK English.
"Vadivel Kumar" <do********@spam-i-love-u.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Did you checked up by changing your
machine date format (Regional Settings)
to UK type?

Vadivel Kumar
http:\\charpblogs.blogspot.com

"Nick" <Ni**@NTWorks.no.spam.fsnet.co.uk> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Hi,

I'm entering a date into an SQL server using an Infragistics control. The
control picks the date format up from the system setting (UK). When the
date is entered into the database, it thinks its in US format and
switches the month & day.

In the stored procedure thats storing the data I have 'SET DATEFORMAT
dmy' which I though was supposed to tell SQL that incoming dates are in
the format specified, rather than the default mdy.

Can anyone help?

Thanks

[IPGrunt]

"Nick" <Ni**@NTWorks.no.spam.fsnet.co.uk> confessed in
news:e9**************@TK2MSFTNGP10.phx.gbl:

Hi,

I'm entering a date into an SQL server using an Infragistics control. The
control picks the date format up from the system setting (UK). When the date is entered into the database, it thinks its in US format and switches the
month & day.

In the stored procedure thats storing the data I have 'SET DATEFORMAT dmy' which I though was supposed to tell SQL that incoming dates are in the
format specified, rather than the default mdy.

Can anyone help?

Thanks

What is your default language set to? It defaults to English, which is
American english, and will do a mdy format.

You want British English, which defaults to dmy

You can do this in Enterprise manager (Server properties), with the SET
LANGUAGE command in your script, or with sp_setdefaultlanguage (look that
one up...I may have it wrong).

-- ipgrunt

[Matt Berther]

Hello Nick,

This is because the language specified in the sql server install is US English.
What happens when you pull the date back out of the sql server?

I'm guessing it comes back in UK format.

--
Matt Berther
http://www.mattberther.com

Hi,

I'm entering a date into an SQL server using an Infragistics control.
The control picks the date format up from the system setting (UK).
When the date is entered into the database, it thinks its in US format
and switches the month & day.

In the stored procedure thats storing the data I have 'SET DATEFORMAT
dmy' which I though was supposed to tell SQL that incoming dates are
in the format specified, rather than the default mdy.

Can anyone help?

Thanks