date question

[speedy33417]

I'm working with dates in a db that store in a YYYY-MM-DD HH:MM:SS format. What is the easiest way to do the following?

1) Determining what day of the week that is (Mon, Tue...)
2) Adding one day to it (where it calculates a new month, year, leap year...)
3) Adding one hour to it
4) Calculating the difference between dates

Thanks

[ted_chou12]

what you do for getting the (Mon, Tue...), is:
[code]
$date = strtotime($date)
$date = date('D', $date);
[/code]
The rest of them, i am not sure what you mean....
Ted

[kenrbnsn]

In php, take a look at the [url=http://www.php.net/strtotime]strtotime()[/url] and [url=http://www.php.net/date]date()[/url] functions.

[code]<?php
$str = '2008-02-28 23:30:30';
echo date('D',strtotime($str)) . '<br>'; // day of week
echo date ('Y-m-d',strtotime($str . ' + 1 day')). '<br>' // add 1 day
echo date ('Y-m-d g:i A',strtotime($str . ' + 1 hour')) . '<br>' // add 1 hour
?>[/code]

Ken