Re: Managing DATE in FORMS
Date: 1997/02/27
Message-ID: <19970227011200.UAA29392_at_ladder02.news.aol.com>#1/1
>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';)
When you do a select in sqlplus you need to use 'when
ins_date='02-JAN-97'' which is the default date format. To get back rows
using your query, you would need to do:
SELECT * FROM EMP where to_char(ins_date,'mm/dd/yy') = '01/02/97'
If you use a date format of mm/dd/yy in the form, you will be able to query using '01/02/97'.
Tracy Nasset Received on Thu Feb 27 1997 - 00:00:00 CET