millsy007 Posted February 25, 2009 Share Posted February 25, 2009 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? Link to comment https://forums.phpfreaks.com/topic/146864-adding-to-datetime-in-update-query/ Share on other sites More sharing options...
HuggieBear Posted February 25, 2009 Share Posted February 25, 2009 Try this Replace your *+ 45 minutes* with + INTERVAL 45 MINUTE Regards Rich Link to comment https://forums.phpfreaks.com/topic/146864-adding-to-datetime-in-update-query/#findComment-771061 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.