Hi,
I have one table with columns one for sysdate and current_date
for every 5 minites one record will be inserted into that table via proc.
CREATE OR REPLACE PROCEDURE Prc
AS
v_sysdate DATE;
v_current_date DATE;
BEGIN
SELECT SYSDATE,CURRENT_DATE INTO v_sysdate,v_current_date FROM dual;
INSERT INTO TM VALUES (v_sysdate,v_current_date);
END ;
/
Here when i used to select sysdate and current_date i am getting the different time for both sysdate and current date. and with anonymous block also i am getting the different time.
while inserting with proc same time getting inserted into the table.
Can u help me in this......
Thank you
SKPR