Formatting timestamps retrieved in a sql result set

[Narayan, Anand]

After executing a query I want to format any date and time values
using a custom pattern before displaying them.
How would I accomplish this?

Heres the query I am executing in my JSP:
<sql:query var="results" scope="session">
SELECT parameter.PARM_ID "id",
parameter.LAST_CHANGE_DATE "updateTime",
parameter.LAST_CHANGE_BY "updateUser"
FROM PARAMETER parameter
ORDER BY parameter.LAST_CHANGE_DATE asc,parameter.LAST_CHANGE_BY asc
</sql:query>

Here is part of the display code. I want to format ${row.updateTime}
to a different date time format.   THANKS

<c:forEach var="row" items="${results.rows}">
...
...
...
<tr class=<c:out value="${rowClass}"/> >
  <td class="resultDataCellCenter">&nbsp;<c:out value="${row.id}" /></td>
  <td class="resultDataCell">&nbsp;<c:out value="${row.updateTime}" /></td>
  <td class="resultDataCell">&nbsp;<c:out value="${row.updateUser}" /></td>
</tr>
</c:forEach>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]