Mysql-Datetime addition help

[rupam_jaiswal]

Hi,

I have a table tableA with fields id,item,sent_to,date_posted (datetime), delivery_hrs(int(2))

 

date_posted is time at which record is inserted into table, delivery_hrs in hrs (int)

 

Here I want records whose date_posted when added to delivery_hrs results in date lesser than or equal to current date and time.

eg

If date_posted = '2010-01-13 02:30:00', delivery_hrs = 2, current datetime = '2010-01-13 05:30:00'

then delivery_time = date_posted + delivery_hrs i,e '2010-01-13 04:30:00'

which is lesser than current datetime = '2010-01-13 05:30:00'.

 

What will be the sql for this??

 

Thanks in advance!!

Regards

[Mchl]

SELECT ... FROM tableA WHERE date_posted + INTERVAL delivery_hrs HOUR <= NOW()