2 Replies Latest reply: Aug 22, 2013 6:17 AM by 789736 RSS

    Date comparison issue

    789736


      HI guys,

       

      Was wondering if anyone could help me out.  I currently have an item on my form which contains a full date ie. 01/01/2013 14:30:00 however I am only interested in the time section of this and am trying to compare it with a value using the following code:

       

      IF to_char(to_date(name_in('appointment.starttime'),'HH24:MI:SS')) = '14:30:00' then

           ....

               ...

      end if;

       

      However this seems to be giving me errors, I assume it is something to do with my date comparison and would be grateful for some help with this.

       

      Thanks.