| From: | Jan Theofel <theofel(at)etes(dot)de> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | age command |
| Date: | 2002-08-13 11:56:46 |
| Message-ID: | 3D58F3FE.8029BB50@etes.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a short equstio anbout the age command:
When I use for example
age(timestamp('2002-08-13'), timestamp('2002-08-12')
I get "1 day" and for
age(timestamp('2002-08-13'), timestamp('2002-07-13')
I get "1 mon".
But what I need is the total difference in days as integer.
How can I get this?
Thanks,
Jan
--
Jan Theofel Fon: +49 (7 11) 48 90 83 - 0
ETES - EDV-Systemhaus GbR Fax: +49 (7 11) 48 90 83 - 50
Libanonstrasse 58 A * D-70184 Stuttgart Web: http://www.etes.de
______________________________________
Inflex - eMail Scanning and Protection
Queries to: postmaster(at)etes(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2002-08-13 12:18:21 | Re: [GENERAL] Linux Largefile Support In Postgresql RPMS |
| Previous Message | pginfo | 2002-08-13 11:19:14 | Very slow insert speed |