Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Feb 2009
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Datetime field in a Query

    Hello

    I want to run a query to update my 'journey' table. The table contain a list of individual journeys that make up the overall trip('shuttle'). I want to add departure times for each individual journey, these are based on the overall shuttle departure time.
    For example for the second part of the journey I would set the journey departure time to be 45 minutes after the initial shuttle departure:

    UPDATE journey, shuttle
    SET journey_dttm = shuttle.depart_dttm *+45 Minutes*
    WHERE journey.shuttle_id = shuttle.id
    AND journey.route_id = '2'

    However I am not sure how I should format the set part of my query?

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,862
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    ....set journey_dttm= date_add( `shuttle.depart_dttm` , INTERVAL 45 MINUTE ) ....
    see http://dev.mysql.com/doc/refman/5.1/...ction_date-add
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #3
    New Coder
    Join Date
    Feb 2009
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

    Thanks, just the job


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •