How do I add 12 hours to NOW()

[Issa Fox]

The following code allows a list of seminars to display on a homepage:

$sql = 'SELECT ID,title,division,startdate,enddate,time,location 
               FROM event 
               WHERE category="1" AND startdate > NOW()
               ORDER BY startdate, enddate 
               LIMIT 4';

The first seminar will only show up until the time of the conference. I would like for it to display for 12 hours after the conference occurs. How do I make that happen?

[dlite922]

Issa Fox, welcome to Bytes!

In this instance you can do it with PHP and replace NOW() with a calculated time, but I suggest you go the MySQL route because it's quicker.

http://dev.mysql.com/doc/refman/5.1/...ction_date-add

like so: DATE_ADD(NOW(), INTERVAL 12 HOURS)

Cheers,

Dan

[HaLo2FrEeEk]

Or:

strtotime("+12 hours")

Should also work, and saves you from calling the now() function AND the date_add() function.

[dlite922]

There's only one way to settle this: Benchmarking.

Somebody should create a 1,000,000 row table with a string and a random date 1979-Present. Then run +12 hour Select commands on a random number of records 1-n at a time using each of the methods.

My bets are on MySQL.

Cheers!

Dan