Mysql-Datetime addition help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
rupam_jaiswal
Forum Newbie
Posts: 22
Joined: Thu Jun 05, 2008 12:54 am

Mysql-Datetime addition help

Post by 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Mysql-Datetime addition help

Post by VladSun »

There are 10 types of people in this world, those who understand binary and those who don't
Post Reply