Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: to_date function
"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