Retreiving all jobs logged in the last hour

Calahan

I've been looking through the date() function, strtotime() function, TIME_TO_SEC function, and others and I keep running into problems.
I have a column with the datetime entered as follows:

2004-02-25 18:09:26

I want to use a select statement to extract all entries that were entered within the last hour. So far I have been approaching it from the angle of retreiving all of todays jobs and then trying to extract just the time from the results so that I could use them in a calculation to pull up all jobs entered within the last hour.
I get the feeling that I'm approaching it from completely the wrong angle and the process could be a lot simpler so I thought I'd check with those in the know before continuing to play.....

YappyDog

Is your database column defined as some sort of character type column that you are storing formatted date information in, or is it some sort of date type column that you are extracting formatted data from?

Calahan

Yes, its a column with a datatype of datetime so all data entered into the column is entered in the format 0000-00-00 00:00:00.

YappyDog

You should be able to do something like:

Select col1, col2, col3 from myTable
where myDateEntered > '2004-02-25 17:09:26'

to get out just the records entered in the past hour.

You can probably build a variable to use by using just the date() function. But, you may need to use the mktime() function as well. The following code has not been tested:

$date = date("Y-m-d H:i:s",time() - 3600);
$sql = "Select col1, col2, col3 from myTable where myDateEntered > '$date'";

http://us2.php.net/manual/en/function.date.php
http://us2.php.net/manual/en/function.mktime.php