I've never used that taglib, but ResultSet.getString returns a String, not a
Date. Try ResultSet.getDate.
Quoting Jeff Self <[EMAIL PROTECTED]>:
> I've got a JSP page that is retrieving information from a PostgreSQL
> database. One of the fields is a datefield. Here's the code to what I'm
> displaying:
>
> while (rs.next()) {
> %>
> <tr>
> <td><%= rs.getString("position_code") %></td>
> <td><%= rs.getString("effective_date") %></td>
> </tr>
>
> When it displays, the date shows up in the following format: 2002-11-14
>
> I'd like it to show up as '11-14-2002'. I'm trying to use the datetime
> taglib so I tried it like this:
>
> <td><dt:format pattern="mm/dd/yyyy"><%=rs.getString("effective_date")
> %></dt:format></td>
>
> But when I run the JSP now, It says invalid date instead of showing the
> date.
>
> What am I doing wrong?
>
>
> --
> Jeff Self
> Information Technology Analyst
> City of Newport News
> Personnel Department Suite 200
> 700 Town Center Drive
> Newport News, VA 23606
> 757-926-1810
>
>
> --
> To unsubscribe, e-mail:
> <mailto:taglibs-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:taglibs-user-help@;jakarta.apache.org>
>
--
Kris Schneider <mailto:kris@;dotech.com>
D.O.Tech <http://www.dotech.com/>
--
To unsubscribe, e-mail: <mailto:taglibs-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:taglibs-user-help@;jakarta.apache.org>
