jstl and oracle date format

Thread view:

Peter Parker - 24 Aug 2006 09:54 GMT

Is it possible to format the parameter date for oracle query in jstl? For
example, I did the following :

<sql:query var="data" dataSource="${connection}">
select some_name from some_table where birth_date = ?

<sql:param value='${to_date(param.birth_date, "dd/mm/yyyy")}'/> <=
this line does NOT work.
</sql:query>

Please help. Thanks.

Reply to this Message

Mindundi - 24 Aug 2006 23:11 GMT

<sql:query var="data" dataSource="${connection}">
select some_name from some_table where birth_date =
to_date("<fmt:formatDate value='${param.birth_date}'
pattern='dd/mm/yyyy'/>", "dd/mm/yyyy")
</sql:query>

Try this one or something similar. fmt are standard formatting tags of jstl.
Good luck, spidey.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...