In the example below, the SQL UPDATE statement is used to update the LASTUPDDTTM field along with a few other fields.
UPDATE PS_JOBCODE_TBL
SET US_SOC_CD = ‘ABC’, LASTUPDOPRID = ‘PS’, LASTUPDDTTM = TO_TIMESTAMP(TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD-HH24.MI.SS'), 'YYYY-MM-DD-HH24.MI.SS.FF’)
WHERE JOBCODE = ‘XYZ’;