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
2423
Brahmanatha Swami
September 02, 2016 07:35PM
Re: Calculation from time stamps through to amount due
1216
Peter Brawley
September 02, 2016 09:26PM
Re: Calculation from time stamps through to amount due
1171
Brahmanatha Swami
September 03, 2016 06:42PM
Re: Calculation from time stamps through to amount due
1156
Brahmanatha Swami
September 03, 2016 06:51PM
Re: Calculation from time stamps through to amount due
1269
Peter Brawley
September 03, 2016 07:23PM
Re: Calculation from time stamps through to amount due
1388
Kailas Natha
September 03, 2016 08:01PM
Re: Calculation from time stamps through to amount due
1197
Peter Brawley
September 04, 2016 12:01PM
Re: Calculation from time stamps through to amount due
1251
Kailas Natha
September 04, 2016 01:29PM
Re: Calculation from time stamps through to amount due
1341
Peter Brawley
September 04, 2016 01:42PM
Re: Calculation from time stamps through to amount due
1237
Kailas Natha
September 04, 2016 04:45PM
Re: Calculation from time stamps through to amount due
1194
Peter Brawley
September 04, 2016 04:53PM
Re: Calculation from time stamps through to amount due
1277
Kailas Natha
September 04, 2016 07:32PM
Re: Calculation from time stamps through to amount due
1256
Peter Brawley
September 04, 2016 09:30PM
Re: Calculation from time stamps through to amount due
1249
Kailas Natha
September 05, 2016 02:46PM
Re: Calculation from time stamps through to amount due
1303
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.