title: DB2: Construct Variable inside stored procedure with current date?
body: <p>I have a stored procedure that basically updates the LASTUPDATE times of some rows and I want to have a variable inside the stored procedure that is basically: <code>Date + " " + "20:30:00"</code> So when the stored procedure is run it looks something like this:</p>
  
  <pre><code>update 
      person 
  set 
      LASTUPDATETIME='2012-06-18 20:30:00', 
      NAME='Mike', 
  where (
      SOME_PK='123'
  );
  </code></pre>
  
  <p>but if I was to run the stored procedure tomorrow it would look like so:</p>
  
  <pre><code>update 
      person 
  set 
      LASTUPDATETIME='2012-06-19 20:30:00', 
      NAME='Mike', 
  where (
      SOME_PK='123'
  );
  </code></pre>
  
  <p>P.S The time never changes, it should always be 20:30:00 no matter when the procedure is called, I’m just interested in the date with the format Year-Month-day.</p>
  
  <p>Thanks for any help!</p>