Thank you both.
Will try the suggestion and let you know the status.
Regards,
Akhila
AkhilaReddy
Last Activity: Apr 17 '15, 04:43 AM
Joined: Mar 16 '15
Location:
-
how to update current date and current time in DB2 table
Hi Experts,
I am new to SQL, trying to update the table with processed date (current date) and time(currenttim e).
I am picking up the data and updating two fields processedDate (8, YYYYMMDD) and processed time(6, HHMMSS).
Picking the data from DB2 table:
SELECT columns FROM schema.table WHERE ProcessedDate= 0 AND processedTime= 0 ORDER BY column (orderNumber)
Update the processedDate:...
No activity results to display
Leave a comment: