Tuesday, September 09, 2008

oracle sql update current date into database

UPDATE S_UNIQUEIDSET
set CURRENTDATE = (select sysdate from dual )
WHERE APPNAME='EURL'

UPDATE E_NOTIFICATION
set DATELASTPROCESS = to_date(sysdate,'YYYY-MM-DD HH24:MI:SS')
where mapid = 'abc'

1 comment:

Anonymous said...

UPDATE S_UNIQUEIDSET
set CURRENTDATE = sysdate
WHERE APPNAME='EURL'