Date Calculations

[Anon]

Hi,

Is there an easy way to obtain the number of days between two dates ?

I have an indate and outdate field (type date) in postgresql, and want to calculate the number of days between the two dates.

Currently I am splitting the date into three variables, but there are so many factors to be taken into account, leap year, month changes, negative days (eg in might be 2001-03-19 and out might be 2002-01-03) so even there you have cross month and year calc to keep in mind.
Regards

Wilhelm

[Anon]

I would take it to a unix timestamp.
look at the function mktime().

That will give you number of seconds since Jan 1 1970, and that makes it very easy to do math with.

[wilhelm]

Thank you a lot that was a great help.

All working perfectly.

Wilhelm