cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefano Mazzocchi <stef...@apache.org>
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.
<stefano@apache.org>                             Friedrich Nietzsche



Mime
View raw message