jstl reformat date

[liliya woland]

Hello,
I have dates coming from mysql database in format
2006-11-20 00:00:00.0
I get them with the code below. I wonder if there is a way to use some sort of jstl library to use the space between date and time and get rid of the time (ie keep only 2006-11-20 part of the string). Thanks in advance.

    
<c:forEach var="row" items="${rs.rows}">
<tr><td width='80'>${row.adddate}</td></tr>
</c:forEach>

[Carol Enderlin]

Have you looked at the jstl formatting actions?

e.g. <fmt:formatDate />

Do you have a copy of the jstl spec? The JspFaq has links to the specs.

[Bear Bibeault]

Originally posted by liliya woland:

I have dates coming from mysql database in format
2006-11-20 00:00:00.0

Unless you are storing the dates in the DB as strings (you aren't, are you?), dates have no format associated with them until printed out.

I wonder if there is a way to use some sort of jstl library to use

Have you checked with the JSTL Specification? You will find that the answer is "yes".

[liliya woland]

I store the date in the database as DATETIME, which means I wont be able to use the jstl library you were mentioning above.

[Bear Bibeault]

Why not?

[liliya woland]

For some strange reason, when attempt using fmt:formatDate with the date that I have or with the date from java.util.Date I get same error about attribute value. I do include the library in my jsp page.

    
<fmt:formatDate value="${row_bgroup.adddate}" type="DATE" pattern="dd/MM/yyyy"/>
OR
<jsp:useBean id="now" class="java.util.Date" />
<fmt:formatDate value="${now}" type="DATE" pattern="dd/MM/yyyy"/>

I get this error
org.apache.jasper.JasperException: /eng/episFindResponse.jsp(133,3) According to TLD or attribute directive in tag file, attribute value does not accept any expressions

[Bear Bibeault]

That is usually a sign of mismatched JSP and JSTL versions. What versions of JSP and JSTL are you using? (according to forum instructions you should have already included this information).