Mysql-Datetime addition help

[php_techy]

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

[gurmeet]

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

use the int data type instead of date time to store dates....

then calculate the values by dividing i.e.
int date is saved as a seconds, to get the day value divide it by
( 60*60*24)