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? Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.