Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Managing DATE in FORMS
Paolo Dall'Olio wrote:
>
> I'm in trouble for the following problem:
>
> In a Form (dev/2000 1.3 x win95) I have a DATE field corrisponding to
> a database DATE field ... when I try to make a query on this field (e.g.
> 01/02/97), no record is returned (NLS_DATE_FORMAT is set correctly, both
> on server and client).
> (Similarly in PL/SQL I get nothing if I do: SELECT * from EMP where
> ins_date='01/02/97';)
try where to_char(ins_date,'mm/dd/yy')='01/02/97' Received on Wed Feb 26 1997 - 00:00:00 CST