MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Calculation from time stamps through to amount due
Posted by: Peter Brawley
Date: September 02, 2016 09:26PM

> What am I doing wrong?

One thing: you're failing to check new.start_time and new.end_time before you use them in your calculation.

Another: you're failing to say what the problem is.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Calculation from time stamps through to amount due
2022
Brahmanatha Swami
September 02, 2016 07:35PM
Re: Calculation from time stamps through to amount due
1026
Peter Brawley
September 02, 2016 09:26PM
Re: Calculation from time stamps through to amount due
1017
Brahmanatha Swami
September 03, 2016 06:42PM
Re: Calculation from time stamps through to amount due
989
Brahmanatha Swami
September 03, 2016 06:51PM
Re: Calculation from time stamps through to amount due
1087
Peter Brawley
September 03, 2016 07:23PM
Re: Calculation from time stamps through to amount due
1187
Kailas Natha
September 03, 2016 08:01PM
Re: Calculation from time stamps through to amount due
1005
Peter Brawley
September 04, 2016 12:01PM
Re: Calculation from time stamps through to amount due
1078
Kailas Natha
September 04, 2016 01:29PM
Re: Calculation from time stamps through to amount due
1166
Peter Brawley
September 04, 2016 01:42PM
Re: Calculation from time stamps through to amount due
1059
Kailas Natha
September 04, 2016 04:45PM
Re: Calculation from time stamps through to amount due
1032
Peter Brawley
September 04, 2016 04:53PM
Re: Calculation from time stamps through to amount due
1081
Kailas Natha
September 04, 2016 07:32PM
Re: Calculation from time stamps through to amount due
1097
Peter Brawley
September 04, 2016 09:30PM
Re: Calculation from time stamps through to amount due
1073
Kailas Natha
September 05, 2016 02:46PM
Re: Calculation from time stamps through to amount due
1096
Peter Brawley
September 05, 2016 04:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.