R: how to format

try

SELECT to_char (...)
instead of
SELECT to_date(...)

<javanewbie_at_my-deja.com> wrote in message 7uovmc$b1c$1_at_nnrp1.deja.com...
> 1999-01-01 00:00:00.0
>
> String str2= "select TO_DATE('19990101','YYYYMMDD') from
> foreign_worker_master where " +
> " ( renewal_date > TO_DATE('19990701','YYYYMMDD') and renewal_date <
> TO_DATE('19990801','YYYYMMDD') ) " ;
>
>
> i want the select to return only the date , ie.
>
> 19990101
>
> instead of
>
> 1999-01-01 00:00:00.0
>
>
>
> Thanks anyway.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 22 1999 - 03:02:23 CDT