Re: SQL help

"Axl" <axl_at_nospam.com> wrote in message
news:tnt0o3auqdu92_at_corp.supernews.com...
> 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
>
>

Try leaving out 'fm'

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Aug 18 2001 - 13:43:59 CDT