Re: Calculation from time stamps through to amount due

[Kailas Natha]

delimiter go

CREATE trigger calculate_time_rate
BEFORE insert
ON admin_time_tracker
FOR each row


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

END;
go
delimiter ;


error:

#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 'new.amount_due=(new.elapsed * rate) END' at line 9