Time slow by 30mins

[oracle newbie]

Table
CREATE TABLE "NYP_LIBPORTAL" ."PORTAL_HOME_N ON_LOGIN_LOG"
("LOGDATETIME" DATE DEFAULT SYSDATE,
"COUNTER" NUMBER(6,0)
)

Procedure
create or replace
PROCEDURE library_portal_ home
(ldt portal_home_non _login_log.logd atetime%TYPE,
COT portal_home_non _login_log.coun ter%TYPE)
IS
BEGIN
INSERT
INTO portal_home_non _login_log
VALUES
((sysdate) ,COT);
DBMS_OUTPUT.PUT _LINE('RECORD IS ADDED......!');
COMMIT;
END library_portal_ home;

Result:
DATE COUNTER
----------------------------------------------------------------
26-JUN-07 8:33 401



I have created a procedure above which will have current date and current time. Thus,when I run the procedure, I got the current date but not the current time.

The actual current time is 9:13 and the result came out is 8:33 which somehow is slow by 30 mins. How can I change it to current time (Singapore) ?

[debasisdas]

try changing your system date and time,rebot the system and then execute the procedure.