[solved] MySQL date manipulation

[eluser]obiron2[/eluser]
OK, This is what I did, I hope it helps someone else

In my SELECT statement

Code:

select DATE_ADD(EndDate, INTERVAL 1 DAY) as NewDate

where EndDate is a field in the table that gets selected. If you do this you can't select * from the table, you have to specify all of the fields you want.

This will return the date in EndDate plus 1 day.


drop this in a helper file

Code:

function makeLongDateFromMySQLDate($indate)
{
  // $indate should be in the format 'YYYY-MM-DD' as per the Date format in MySQL
  $x = explode('-',$indate);
  $timestamp = mktime(0,0,0,$x[1],$x[2],$x[0]);
  $outdate=date('l jS \of F Y',$timestamp);
  return $outdate;
}

I am sure someone could make it more flexible if they need to.

This returns the date in a format

"Monday 1st of October 2007"