Postgres Pro
Downloads
Home   >   mailing lists

Days betwen dates - Mailing list pgsql-novice

From Andy Holman
Subject Days betwen dates
Date
Msg-id 3A5B39E4.2D1346C0@i-developit.com
Whole thread Raw
List pgsql-novice
Tree view 
Anyone know how I can just get the number of
days between dates in 2 columns in a query?

I am using something like age('dateone', 'now')
currently but that returns 1 year 10 mons 14 12:53:10
or something of the like. I just want the days between
them. I am using php. Please let me know if you have
any ideas.

Thanks,
Andy

pgsql-novice by date:

Previous
From: Ken Corey
Date:
Subject: Re: Advice on stored proc error handling versus Sybase?
Next
From: Tom Lane
Date:
Subject: Re: Re: Advice on stored proc error handling versus Sybase?