Postgres Pro
Downloads
Home   >   mailing lists

age command - Mailing list pgsql-general

From Jan Theofel
Subject age command
Date
Msg-id 3D58F3FE.8029BB50@etes.de
Whole thread Raw
Responses Re: age command  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@etes.de

pgsql-general by date:

Previous
From: Christian Mock
Date:
Subject: Re: performance with triggers depends on table size?
Next
From: pginfo
Date:
Subject: Very slow insert speed