I'm not sure if this is the right place for this question but here goes. I
am writing a java servlet that creates a SQL statement based on some text
entered from a web page and executes it against a few Oracle tables. My
problem is the syntax to query against a date column. The date is stored in
Oracle one way, but my users will enter the date themselves in a different
format. For example, they could enter 5/4/2001 as the date to query
against. I thought I could use to_char(CreatedDate, 'fmMM/DD/YYYY'), but
that doesn't work. If they enter 05/04/2001 it will work, but I can't count
on them to enter it correctly with 2 digit months and days. I could write
some javascript code on the front end to correct the date, but I know there
must be an easier way to do this. Any ideas?
Thanks,
Axl
Received on Sat Aug 18 2001 - 09:59:27 CDT
