2 Replies Latest reply on Aug 22, 2013 11:17 AM by 789736

    Date comparison issue


      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.