Re: sqlserver ce Valid Date Converted to Null

Hi Joseph,
I tried that but it went through ok. I do't know if i have to check
the regional settings or the sql server settings.It seems that sql
server takes from the regional settings

Rgds

Jadid
Joseph Byrns wrote:
> Could it be that you are having region problems with your date format? i.e.
> US: mm/dd/yyyy and UK:dd/mm/yyyy. It seems a bit of a coincidence that it
> has happened on the 13th day of the 12th month, if you insert 2005-12-11
> does that work?
>
> <jadidk@xxxxxxxxx> wrote in message
> news:1134540449.758798.38470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Dear All,
> > I have implemented a classical push/pull RDA synchronization with
> > windows
> > xp/IIS/sql server 2000 for 3 months now.
> > Today without any warning i have been getting push errors due to
> > inserting
> > null date values .After checking the data,the date
> > is ok (2005-12-13) but it still says that it cannot insert null date in
> > the
> > database
> >
> > Any Help most welcome
> >
> > Rgds
> >
> > Jad
> >

.

Relevant Pages

  • Re: sqlserver ce Valid Date Converted to Null
    ... > the regional settings or the sql server settings.It seems that sql ... > Joseph Byrns wrote: ... >>> Rgds ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: date rendered differently on two computers with same regional settings
    ... The date (datetime) in sql server installed on this computer is also rendered as 13/08/2007. ... What is important is that you are relying on the regional settings at all in the web application. ... Why does the conversion from a string to datetime happen properly with XP box and not with server 2003? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Date format for SQL Select Statements and Internationalization
    ... Regional setting has nothing to do with how SQL Server interprets datetime strings. ... a login does, and also, SET DATEFORMAT and SET LANGUAGE. ... straight to SQL Server without passing it through a proper format function. ... > to SQL Server queries so that regardless of a user's Regional Settings or the ...
    (microsoft.public.sqlserver.programming)
  • Re: Regional settings weird problem
    ... The regional settings on your computer influence how the date is presented ... how SQL Server interprets the dateformat of strings depends on the ... In Enterprise Manager, look under ... In your case this will be English instead of British. ...
    (microsoft.public.sqlserver.clients)
  • Date format for SQL Select Statements and Internationalization
    ... Is there a proper format that we should be passing date/times ... to SQL Server queries so that regardless of a user's Regional Settings or the ...
    (microsoft.public.sqlserver.programming)