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
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.