LinkedIn

Thursday, 12 June 2008

SQL GetDate() in Oracle

SQL GetDate() in Oracle is SYSDATE

For example:
INSERT INTO WORKFLOW_RESULTS
(XML_INPUT, INSERT_DATE, STATUS, PROCESSED_DATE)
VALUES
(
'testing1'
,SYSDATE
,'TTT'
,SYSDATE
)