Interval help... simple

[izbryte]

I have this:

 

mysql_result(mysql_query("SELECT COUNT(*) as Num FROM jobs WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)"),0); 

 

How do I get 26 hours instead of 1 day (24 hours)?

[izbryte]

BTW... I tried:

 

mysql_result(mysql_query("SELECT COUNT(*) as Num FROM jobs WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL '1 2' DAY_HOUR)"),0);

 

but it didn't work. Also, I just noticed i posted this in the wrong forum... sorry. I don't know how to move it.

[Daniel0]

SELECT COUNT(*) AS Num FROM jobs WHERE DATE >= NOW() - INTERVAL 26 HOUR;