title: How to update a date column with sysdate including timestamp in a dynamic sql
body: <pre><code>    CREATE OR REPLACE PROCEDURE TESTPROC
  IS
     l_update_str   VARCHAR2 (4000);
  BEGIN
     l_update_str :=
        'UPDATE XX_TABLE 
               last_update_date = ''' || SYSDATE || ''',
         WHERE     1=1';
  
     EXECUTE IMMEDIATE l_update_str;
  END;
  /
  </code></pre>
  
  <p>I have tried above but it is not working. I have aslo tried using to_date(to_char(sysate)) but the time stamp is missing</p>