DSXchange

Hi I have a table with two columns Employee_id as Varchar(14) and Emp_Joining_Date as timestamp Employee_id Emp_Joining_Date abc 01/04/2004 00:00:00 efg 30/06/2006 00:00:00 I need to design a job to update the same table with the Emp_Joining_Date as one day lesser than the original date.So my output...

Hi All......

Could someone please give a reply.......

Thanks Chulett!

I have looked into the previous posts that you mentioned about.But I could not come to any conclusion from them. I would like to get more clarification.Could you please give more explanation and a solution for the avoiding the error......?