I am working on a project of a car rental at the moment. I want to create a trigger that will calculate the number of days Between 2 dates. and display it in a new column. So... I realised I need to alter my bookings table because I don't have a duration table.
ALTER TABLE bookings ADD The duration varchar(10);
After altering, I think I need to create an update trigger because
DATEDIFF function is used for querying. Could someone help me with this trigger? E.g. Count the amount of days between 10th March and 15th March - 5 days . Any help is appreciated. I'd assume it will be an