MySQL Forums
Forum List  »  Stored Procedures

Re: Stored Procedure
Posted by: Barry Galbraith
Date: November 08, 2015 04:45PM

>..where (PublishDate > @SBlogDate and PublishDate < @EBlogDate)...,

You can simplify this as

..where (PublishDate BETWEEN SBlogDate and EBlogDate)...,

which is ALMOST the same. This version will return where PublishDate includes SBlogDate or EBlogDate as well as those dates between.
This assumes that PublishDate is of type DATE, not TEXT or VARCHAR.

Good luck,
Barry.

Options: ReplyQuote


Subject
Views
Written By
Posted
2412
November 08, 2015 08:28AM
795
November 08, 2015 08:35AM
786
November 08, 2015 12:48PM
Re: Stored Procedure
680
November 08, 2015 04:45PM


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.