Re: Error
Re-read the manual pages on stored routines. If it has a Return statement, it must be created as a function, not a procedure.
Did you try those Convert() calls in the mysql client? Firstday is a date, can't be assigned an int value.
And re-read the manual for If...End If; syntax, also the diff between a Date and a DateTime value.
The complications in your sproc probably aren't needed. Why not just convert the datetimes to ints with unix_timestamp, do the subtraction and return the no. of seconds?
Subject
Views
Written By
Posted
1080
May 08, 2018 12:52AM
Re: Error
463
May 08, 2018 10:49AM
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.