Last twelve hours echoed from MySQL

[suttercain]

Hi everyone,

 

I am so tried but can someone help and show me a basic way to only display the last twelve hours of results from the MySQL?

 

I have a column with the time, how do I only show the last tweleve hours? strtotime?

[Kurrel]

What format is your time stored in the column?

[suttercain]

MySQL default HH:MM:SS = 24:12:12

[redarrow]

somethink like that not sure theo.

 

SELECT * from x where  x = HOUR('$x', INTERVAL - 12 HOUR);

 

[suttercain]

MySQL server version for the right syntax to use near ' INTERVAL -12 HOUR)' at line 1

 

: (

 

$sql = mysql_query("SELECT * FROM latestGreatest WHERE latestTime = HOUR('".$time."', INTERVAL -12 HOUR)") or die(mysql_error());

[redarrow]

TRY THIS PLEASE.

 

mysql_query("SELECT * FROM latestGreatest WHERE latestTime = DATE_SUB('".$time."', INTERVAL 12 HOUR)") or die(mysql_error());

[suttercain]

I didn't get an error... that mean it worked?

 

Thanks!

[jitesh]

SELECT * from table WHERE `feildname` between (CURRENT_TIMESTAMP()) AND (CURRENT_TIMESTAMP() - INTERVAL 12 HOUR)

[suttercain]

Hi Jtesh,

 

I gave it a shot and I am getting back no results, even though I do have an update within the last hour...

[suttercain]

Can I do this just useing a TIME field or must I use a TIMEDATE or something else?

 

Thanks.

 

SC

[suttercain]

I switched over time a timestamp to test out this code

 

$sql = mysql_query("SELECT * FROM latestGreatest WHERE `latestTimeStamp` between (CURRENT_TIMESTAMP()) AND (CURRENT_TIMESTAMP() - INTERVAL 12 HOUR)") or die(mysql_error());
			$total = mysql_num_rows($sql);
			echo "$total";

 

I am still getting zero number of rows, but there should be two.

 

Any advice?

 

Thanks

[jitesh]

SELECT *

FROM DATA WHERE `timefeield` < CURRENT_TIMESTAMP( )

AND `Name` > ( CURRENT_TIMESTAMP( ) - INTERVAL 12 HOUR )