cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefano Mazzocchi <>
Subject Re: How to do formatting of dates and times with SQLProcessor
Date Fri, 03 Dec 1999 19:26:31 GMT
Steve Muench wrote:
> Donald,
> Can't you just rely on the database to format
> the date in the format you want and keep the
> <query> tags simpler?
>   SELECT TO_CHAR(hiredate,'Month DD, YYYY) as hiredate
>     FROM EMP
>       :
> Databases have pretty evolved number/date formatting
> routines that handle all the NLS/locale issues already.

Excuse the stupid question: are these SQL-portable?
> Seems like a problem that you could push down a layer
> and keep the model simpler in the "page"...

You're totally right if the standard uses them, otherwise, Donald is
right to have than handy and provide a new portable layer.
Who's right?

Stefano Mazzocchi      One must still have chaos in oneself to be
                          able to give birth to a dancing star.
<>                             Friedrich Nietzsche

View raw message