Mysql-Datetime addition help

Discussion in 'Databases' started by php_techy, Jan 13, 2010.

  1. #1
    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
     
    php_techy, Jan 13, 2010 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Following query might be helpful..

    What it does is adds delivery_hrs hours to date_posted and then compares it with current timestamp.

    SELECT * FROM tableA WHERE (date_posted + INTERVAL delivery_hrs HOUR) <= NOW()
     
    mastermunj, Jan 19, 2010 IP