Postgres Pro
Downloads
Home   >   mailing lists

Interval to number - Mailing list pgsql-admin

From Gareth Kirwan
Subject Interval to number
Date
Msg-id 00fb01c1fff4$e5030cd0$55eaa8c0@gbjk1
Whole thread Raw
In response to UTF-8 safe ascii() function  (Jean-Michel POURE <jm.poure@freesurf.fr>)
Responses Re: Interval to number  (Brian McCane <bmccane@mccons.net>)
List pgsql-admin
Tree view 
Postgres 7.2
I have an interval selected from a max(occurance) - min(occurance) where
bla.
I now want to multiply this by a rate - to create a charge...

If I use to_char( interval, 'SSSS');
I will get a seconds conversion - but that works on seconds since midnight -
hence
with a one day period.

Are there any better ways of converting a timestamp to an integer?


Thanks

Gareth

pgsql-admin by date:

Previous
From: "shreedhar"
Date:
Subject: Problem in User Securities
Next
From: "Joel Burton"
Date:
Subject: Re: Problem in User Securities