Hi all gurus, appreciate the help previously, I have learn a lot through this forum. now i have this problem while updating a table from second table in the same database. here is the problem. database name = cashier table.A consist = product code, desc, docno, qty, date, amount, total, cost, stat, column data = 1234 ,air , t03 , 2 , 'null', 2.50 , 5.00, 'null' , 'null' table.B consist= docno, date , amount, tender, rounding, gross total, column data = to3 , 2011-01-01 00:00:00 , 5 , 10 , 0 , 5 , now here the problem table.B is summary for table.A and table.A is the detail sale with item. while sync the data loss as you can see the date, cost,stat is null. table.B is complete with all the detail with date. here is what i try to do, I take table.B info and update table.A date only column ignore cost and stat(as that I can get from product table). But both date format are differ table.A date = '2011-01-01' only no time include, but table.B date = 2011-01-01 00:00:00 include time. so how am i update only date without the time with the docno is the index?