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

Home -> Community -> Usenet -> c.d.o.misc -> Re: to_date function

Re: to_date function

From: Jan Schäfer <schaefer_at_imise.uni-leipzig.de>
Date: Tue, 18 Dec 2001 08:50:07 +0100
Message-ID: <9vmsff$jua$1@news.uni-leipzig.de>


"Katak" <kahtat_at_yahoo.com> schrieb im Newsbeitrag news:9vml6r$bhk$1_at_violet.singnet.com.sg...
> dear all
>
> I am having difficulty selecting records based on dates. Can anyone help?
>
> I tried using
> select * from tableA where created_date = to_date('15/12/01',
'dd/mm/yy');
>
> though i have records in the database. i do not get any results executing
> the above mentioned SQL code. anyone can lend a hand on this????? thanks

Is created_date a table column?
If yes then try to use the date with four digits for the year:

to_date('15/12/2001', 'dd/mm/yyyy');

So long,

Jan

--
Received on Tue Dec 18 2001 - 01:50:07 CST

Original text of this message

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