Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Managing DATE in FORMS

Re: Managing DATE in FORMS

From: Mike Sheda <msheda_at_epower.net>
Date: 1997/02/26
Message-ID: <3314F8E1.6E7D@epower.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US