postgresql to_days

[trooper]

Hi

Is there an evqivilent function in postgresql similar to mysql's to_days function.

I want to work out the number of days between ta start date (y-m-d format) and an end date.

Cheers

GM

[toma42]

Get the date from pgsql as a timestamp then use this:

/**
 * Returns number of days between two given dates.
 *
 * @param string year in format CCYY
 * @param string month in format MM
 * @param string day in format DD
 * @param string year in format CCYY
 * @param string month in format MM
 * @param string day in format DD
 *
 * @access public
 *
 * @return int absolute number of days between dates,
 *      -1 if there is an error.
 */

function dateDiff($day1,$month1,$year1,$day2,$month2,$year2)
{
    if(!Date_Calc::isValidDate($day1,$month1,$year1))
        return -1;
    if(!Date_Calc::isValidDate($day2,$month2,$year2))
        return -1;  

    return(abs((Date_Calc::dateToDays($day1,$month1,$year1))
                - (Date_Calc::dateToDays($day2,$month2,$year2))));

} // end func dateDiff

That function is copied from the date/calc.php script in pear

[toma42]

Er, and that function is dependent on the object I took it out of (oops). Anyway, just use that calc.php from pear in your application.