Date format to for evaluation

Hi ,

Here on table FF0911 the datatype of UPDT_DT  is DATE ,  I see the condition UPDT_DT > :p2  does not seem work , even if UPDT_DT less than the value the record is getting applies from source database .

  do I need to change the updt_by format to     to_char (  ','DD/MM/YYYY HH24:MI:SS') or something like this which satisfy the below condition

Select count(*) conflict from  FF0911 where  STATE_NUMBER = :P1 and &
UPDT_DT > :p2"

MAP GIAADMIN. FF0911 , TARGET GIAADMIN. FF0911 , &
REPERROR (21000, DISCARD), &
SQLEXEC (ID lookup, ON UPDATE, &

QUERY "select count(*) conflict from  FF0911 where  STATE_NUMBER = :P1 and &