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:

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


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


...
...
...
 >
   
   
   



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

Re: Formatting timestamps retrieved in a sql result set

[Felipe Leme]

On Monday 28 July 2003 02:26 pm, Narayan, Anand ANarayan-at-e-gatematrix.com 
|jakarta| wrote:
> 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?

You could use the  tag, using the pattern attribute. Something 
like this:

  

Felipe

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