sql – Oracle procedure saving SYSDATE

sql – Oracle procedure saving SYSDATE

In PLSQL you can just assign:

BEGIN

...

  l_date_string := [ || TO_CHAR (SYSDATE, MMDDYYYY-HH24:MI:SS) || ]; 

...

END;

if you insist on sql all you have to do is to add into after select:

BEGIN

...

  -- standard select .. from .. with additional into  
  select [ || TO_CHAR (SYSDATE, MMDDYYYY-HH24:MI:SS) || ]
    into l_date_string 
    from dual;

...

END;

I think this is where your issue might be .

select [||TO_CHAR (SYSDATE, MMDDYYYY-HH24:MI:SS)||] into l_date_string  from dual;

notice the change of the into.

sql – Oracle procedure saving SYSDATE

Leave a Reply

Your email address will not be published. Required fields are marked *