| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> how to format
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 - 01:19:59 CDT
 |
 |