Because formats for dates are so ambiguous, there's no reliable way to
interpret. The is why you'd use the parseDate tag, probably inside a set to
get a date object that you'd then pass to your dateparam thing. Presumably
you could write an el "function" to do that inline if you wanted to out in
the effort to clean your JSP further, as I don't know of such thing
existing (though I can't imagine why it shouldn't, save to discourage
everyone putting all their application logic and validation in JSPs)

On Tue, Aug 20, 2019, 05:22 Kazuaki Miyauchi <> wrote:

> 2019-08-20 16:39 GMT+09:00, Stuart Thiel <>:
> > That's what parseDate does, and why I pointed you at it.
>  I also want to do like int case as following.
> <c:set var="year" value="2019" scope="session"/>
> <c:set var="month" value="8" scope="session"/>
> <c:set var="day" value="20" scope="session"/>
> <sql:setDataSource dataSource="jdbc/kome" var="kome"/>
> <sql:update var="stmt" dataSource="${kome}">
>  insert into test values(?,?)
>  <sql:dateParam value="${year}-${month}-${day}" type="date"/>
>  <sql:param value="Good"/>
> </sql:update>
>  But, of course, this makes
> javax.el.ELException: Cannot convert [2019-8-20] of type [class
> java.lang.String] to [class java.util.Date]
>  So, I'd like to know how to convert Date type using EL writing.
> Is there simple method to convert like 0 + for int case?
>  Regards,                            Kazuaki Miyauchi, Japan
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

Reply via email to