[Zope] select age(birthday) from web_users

[Peter Bengtsson]

Weird. When I use age() via Zope using psycopgda I get
'4 mons 14 days 13:12:36.833098'
i think this is postgresql 8.0 that I'm using. Don't know the
psycopgada version since it doesn't define a version number :(

On 9/30/06, Pavel Zaitsev <pavel at md5.ca> wrote:
> Hi,
> Query in the topic from postgresql database returns from psql line,
> years, months and days. From testing same query in zope i get only days,
> is there a way to force it to return as psql does return it?
> As in:
> brain_dev=# select age(birthday) from web_users;
>           age
> ------------------------
>  13 years 8 mons 8 days
> (записей: 6)
>
> brain_dev=#
>
> thanks
> Pavel
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>


-- 
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com