Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between sysdate and current date in proc

636387Sep 24 2009 — edited Sep 24 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2009
Added on Sep 24 2009
6 comments
6,139 views