Help

  • Thread starter Thread starter Sudheer Kareem
  • Start date Start date
S

Sudheer Kareem

Dear all,

I Have done a project in vb.net using sql server as backend.when the
developing stage the quries are working fine.but after creating the setup
and instalation in the client place when i am trying to save a query one
error is poping up saying "the conversion of data type to a datetime data
type resulted in an out of range date time value".i am unable to generate
the same error in the developing stage.can any body help me

thanks and Regards

Sudheer

--
 
With respect . . . . . .

Cleary there is a mismatch between your runtime ( where is this being run
from ) and the SQL schema, date format. You need to do some diagnbostics of
your own here to define the problem to a finer level of granularity. You
cant really expect to get an answer with such a nebulous description.

Also, I would repost ( with more data ) to the adonet newsgroups as there
are more expeirenced people in SQL servers likely to be able to respond
quickly to your request for help than here.

Regards - OHM



Sudheer said:
Dear all,

I Have done a project in vb.net using sql server as backend.when
the developing stage the quries are working fine.but after creating
the setup and instalation in the client place when i am trying to
save a query one error is poping up saying "the conversion of data
type to a datetime data type resulted in an out of range date time
value".i am unable to generate the same error in the developing
stage.can any body help me

thanks and Regards

Sudheer
Click to expand...

Regards - OHM# OneHandedMan{at}BTInternet{dot}com
 
Hi Sudheer,

There was a problem yesterday in this newsgroup about datetime and someone
was converting the hardcoded string "12/13/2002".

Herfried did place a sentence telling that this was not good practise for
globalisation.

I had to think on that when I saw your message. Has your development
computer maybe US settings while the user computer has it from your country
and are those different with date and time?

Cor
 
Hi,

I've always found it best to convert dates to "yyyy-mm-dd" format before
passing to SQL Server. This should avoid any confusion with local settings.

Mystic Mong
 
Back
Top