enable datetime type field query in Oracle Form 6.0

If your company is still using Form 6.0 and unfortunately you have to query inside a "datetime" field.

Unlike "char" or "number" field, the "Datetime" field does not sopport ">/<" notation. that means, you can not type ">/<" inside a datetime field to execute a later than or earlier than query. However to change to format of this field, may effect the other fileds and cause unnecessary changes. 

Here is a quite easy and effective way to solve your problem.

COPY (‘>=’ || to_char(:datablock.field1, ‘yyyy-mm-dd hh24:mi:ss’),’:datablock.field2′) ;

here assume field1 is the field you type in a datetime and "field2" is the actual datebase field, which you wanna compare your input with.

in this way, the notation ">=" will be put into your sql sentence to excecute.