Adding to datetime in Update Query

[millsy007]

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?

[HuggieBear]

Try this

 

Replace your *+ 45 minutes* with

+ INTERVAL 45 MINUTE

 

Regards

Rich