Conditional SQL Update +100 years

• kenclarke

  Grasshopper

  Points: 16

  More actions

  October 3, 2008 at 7:10 am

  #193637

  Hi,

  I need to update a a load of DOB fields where the date is currently 20## instead of 19## eg. 15/08/24 should read 15/08/1924.

  How do I update using the following type of statement:

  update

  Table Name Here

  set

  dateofbirth = current DOB (-100 years)

  where

  Record = A

  Any help greatly appreciated.

  Ken

• Karthigai Rajan

  Mr or Mrs. 500

  Points: 500

  More actions

  October 3, 2008 at 7:51 am

  #880466

  Hi,

  The following query will do that.

  update

  Table Name Here

  set

  dateofbirth = dateadd(year,-100,dateofbirth)where

  Record = A

  Hope this helps you.

  Thanks