View Full Version : Updating Datetime field in a Query

02-25-2009, 04:26 PM

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?

02-25-2009, 04:39 PM
....set journey_dttm= date_add( `shuttle.depart_dttm` , INTERVAL 45 MINUTE ) ....
see http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

02-25-2009, 09:08 PM
Thanks, just the job