Post reply

Datetime quirk?

  • July 21, 2003 at 5:17 pm

    #64792

    Hi All,

    I have an updategram that I'm using to insert into a table. One of the fields in the table is dateTime. The updategram passes in the date in the format of dd/mm/yy and I've found that in cases where the year is less than 1950, say 03/14/42, it gets entered into the table as 03/17/2042. I have been able to deal with it when I'm creating the updategram, but I'm interested to know what's going on and if it can be changed within SQLServer 2000?

    Thanks

  • July 21, 2003 at 5:24 pm

    #466307

    See SQL Server Books Online for

    SET DATEFORMAT dmy

    EXEC sp_configure 'two digit year cutoff'

  • August 14, 2003 at 10:28 am

    #469991

    Another thing you must try would be:

    In SQL Eenterprise Manager; right click on server issue. Select PROPERTIES and SERVER CONFIGURATION. There you have the option of change the range or year used to.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply