DATEDIFF gives the date difference between two dates i.e number of days and I am adding these days to the current date by using DATEADD function. For further info please...

Hi vikramnat,

Try using the following query

update table_name set col_name =DATEADD(d,DATEDIFF(d,col_name,'9-1-2003'),col_name) where .......