Re: Calculation from time stamps through to amount due

[Kailas Natha]

set new.elapsed=(TIMESTAMPDIFF(MINUTE , new.start_time , new.end_time ) / 60.00);
set new.amount_due=(new.elapsed * rate)

generates this error:

The following query has failed: "CREATE DEFINER=`devhap`@`localhost` TRIGGER `calculate_elapsed_time` BEFORE INSERT ON `admin_time_tracker` FOR EACH ROW set new.elapsed=(TIMESTAMPDIFF(MINUTE , new.start_time , new.end_time ) / 60.00); set new.amount_due=(new.elapsed * rate)"
MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set new.amount_due=(new.elapsed * rate)' at line 2