On Fri, Aug 22, 2003 at 13:00:57 -0400,
"Johnson, Shaunn" <[EMAIL PROTECTED]> wrote:
> Howdy:
>
> I want to convert all of this into days, but
> I don't think I can use 'to_char' because
> I get things like this:
Converting intervals to days is a problem because months are treated as
having 30
Title: convert interval info into days
Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
How can I convert data in a table that has been created
with the INTERVAL data type into a numeric format?
Say, I have a table with this type of data:
[snip]
-1 years | 00:00
00:00 | 1 y
