Adding a value to a datetime column - error

• meghardy

  Default port

  Points: 1453

  More actions

  June 12, 2003 at 5:26 am

  #81833

  Hi,

  When trying to change a date on an application, an error occurs saying

  'Adding a value to a 'datetime' column caused overflow'.

  This is something I have never heard of and cannot find anything out about it.

  Any ideas?

  Thanks

  MH

• paulhumphris

  Hall of Fame

  Points: 3496

  More actions

  June 12, 2003 at 5:29 am

  #461029

  This could be something to do with the date format in which your application is passing the datetime data to SQL.

  Try to ensure that the application is using either a 'yyyymmdd' or 'dd mmm yyyy' format.

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  June 12, 2003 at 5:30 am

  #461032

  Is the format of the date correct?

  By using a date of 10/10/02 SQL could get very confused.

  What sound like you are doing is giving sql a date 30/10/2002

  SQL is trying to use 30 as the month (American)

  As a rule of thumb I always convert date to something that cannot be argued.

  01 Jan 2002.

  This might be your problem or I missed the boat. 🙂

  Cheers,

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 12, 2003 at 6:39 pm

  #461187

  Check the data type of your app. variable

  Your app. variable is most likely wrong data type.

  MW

  Edited by - mworku on 06/12/2003 6:40:36 PM

  
  MW