Re: Managing DATE in FORMS

From: Mal Heseltine <mth_at_qld.mim.com.au>
Date: 1997/02/27
Message-ID: <331551AA.4DF4@qld.mim.com.au>#1/1

Are you sure it is not a DATETIME field?.

try trunc(ins_date)='01/02/97'

Mike Sheda wrote:
>
> 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 Thu Feb 27 1997 - 00:00:00 CST