jstl and oracle date format

[Peter Parker]

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 = ?

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

Please help. Thanks.

 

[Mindundi]

<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.