8 Replies Latest reply: Feb 19, 2013 5:02 AM by 985680 RSS

    View Criteria and ADF dates

    985680
      Hello All,
      I am using JDevloper 11.1.2.3.0

      I am creating a view criteria on a calendar view page.
      I have an attribute in my DB called start_date of type timestamp.

      I want the view object where clause to check if the reminder is set to ON and if start_date is equal currentdate + 1 hour
      SELECT Calendar.DESCRIPTION, 
             Calendar.END_DATE, 
             Calendar.ID, 
             Calendar.PROVIDER, 
             Calendar.REMINDER, 
             Calendar.START_DATE
      FROM CALENDAR Calendar
      WHERE  ( (UPPER(Calendar.REMINDER) = UPPER('ON') ) AND Calendar.START_DATE = ...
      what should the value be ? I thought about sysdate+1/24 but how should I write it ?

      thanks a lot


      FARAJ