Cherry's Playground
Journey
Home
Menu 1
Drop 1-1
Drop 1-2
Drop 1-3
Menu 2
Drop 2-1
Drop 2-2
Menu 3
Drop 3-1
Drop 3-2
Drop 3-3
Drop 3-4
Menu 4
Menu 5
AllBlogTools
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'
September 23, 2008 at 9:48 AM
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
1 comment:
UPDATE S_UNIQUEIDSET
set CURRENTDATE = sysdate
WHERE APPNAME='EURL'
Post a Comment