check out the to_char and to_date functions in Oracle, they will do 
what you want

> -----Original Message-----
> From: axn187@y... [mailto:axn187@y...]
> Sent: 03 January 2001 21:19
> To: axn187@y...; pro_jsp@p...
> Subject: [pro_jsp] Date field usage between jsp page and database
> 
> 
> I have a jsp page that takes date input as string...I then 
> need to create 
> an sql using these date fields to the oracle database...could anyone 
> explain to me how this can be done...also, date fields off the oracle 
> database when returned back to jsp page need to be converted 
> to strings.
> 
> Please assist!!!

--- 
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development, 
Web Development, Networking & Communications, and Hardware & Systems.  
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to pro_jsp as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-pro_jsp-$subst('Recip.MemberIDChar')@p2p.wrox.com