2 Replies Latest reply: Jul 8, 2007 11:52 AM by 807605 RSS

    adding current_timestamp

    807605
      Hi,

      I am currently trying to add a timestamp+(variable) to my mssql database via a JSP. I can add the simple time stamp by doing the following:

      ...
      PreparedStatement ps = connection.prepareStatement("INSERT INTO table1 VALUES (?,?,?, CURRENT_TIMESTAMP+5)");
      ...

      ...which adds 5 days to the current date. However if i wanted to replace '5' with a variable how do i go about doing this. i have tried for example:

      ...
      String extraDays = 5; (just for example)
      ...
      PreparedStatement ps = connection.prepareStatement("INSERT INTO table1 VALUES (?,?,?, CURRENT_TIMESTAMP+extraDays)");
      ...


      also tried by replacing with:

      CURRENT_TIMESTAMP+"extraDays"
      CURRENT_TIMESTAMP+'extraDays'

      but none of them seem to work.

      Any help would be gladly appreciated.

      Message was edited by:
      haggard17