Re: [Zope] select age(birthday) from web_users

2006-09-30 Thread 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 <[EMAIL PROTECTED]> 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@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
___
Zope maillist  -  Zope@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 )


[Zope] select age(birthday) from web_users

2006-09-29 Thread Pavel Zaitsev
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@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 )