July 10, 2013

to search whether a date is in between two date fields through my sql query

How to search whether a date is in between two date fields through my sql query




see the below table

----------------------------------------------------------
id | start_date    | end_date     | amount | status  | particular
-----------------------------------------------------------
1  | 12-02-2012 |13-07-2013  | 1729    | active  | Zulily
-----------------------------------------------------------
2  | 07-02-2014 |23-02-2014  | 1989   | active  | IOS 7
-----------------------------------------------------------
3  | 07-03-2014 |16-03-2014  | 1987    | active  | Windows 8.1
-----------------------------------------------------------
4  | 12-06-2014 |13-07-2014  | 1987    | active  | Ouya
-----------------------------------------------------------
5  | 12-10-2014 |28-11-2014  |2013    | active  | Comet C/2012
 -----------------------------------------------------------




 SQL query : select * from tbl_interest_rates where now() between start_date and  end_date;
Dated : 10 jully 2013

result  : 1  | 12-02-2012 |13-07-2013  | 1729    | active  | Zulily



This example will find whether the given date is inbetween dates in the given table.

+Shimjith Kumar
+Vipin Cp


http://belazy.blog.com/

11 comments:

  1. AnonymousJuly 13, 2013

    A colleague referred me to this website. Thanks for the details.


    my homepage rubbish removal adelaide :: http://www.easyskips.com.au :
    :

    ReplyDelete
  2. Thanks for your Heads up I've been searching for somewhere to acquire some cheap games for my WII. Do you know wherever it is possible to get the game cube games cheap?

    My web site - coursesmart offline error []

    ReplyDelete
  3. Good internet site! I genuinely adore how it really is simple on my eyes plus the data are well written.
    I am wondering how I may very well be notified when a whole new submit has been manufactured.
    I've subscribed to your feed which must do the trick! Have a good day! "You can discover what your enemy fears most by observing the means he uses to frighten you." by Eric Hoffer.

    Also visit my web site ... vbulletin 5 installation

    ReplyDelete
  4. Ever consider that it might be Microsoft's fault? They've
    got earned a reputation for breaking the way 3-rd party software interacts with their
    software.

    Also visit my web site: adobe creative suite 5 production premium

    ReplyDelete
  5. Thanks for this useless piece of information, yes it may possibly
    dry out liquid, but it aint gonna fix the corrosion
    that will eventually kill the phone. I can see lots of individuals over the upcoming
    few weeks with "but I put it in a bag of rice" remarks.

    Look into my blog post; advance auto parts monster jam coupons

    ReplyDelete
  6. Immediately after checking out numerous the blog site articles in your web site,
    I critically like your method of blogging. I saved it to my
    bookmark site list and can be checking back within the near potential.
    Please check out my website at the same time and allow me know how you feel.


    Stop by my web site: Coupon codes for target furniture

    ReplyDelete
  7. Buddypress is awesome. For that devs or any that knows, what
    type of backend do the big social networks use?

    Do sites like Facebook, Yelp etc. have admin backends that
    seem one thing like this? I'm wondering what theirs appears like just out of curiousity and to know what buddypress lacks/how it compares to building a site from scratch.

    Look at my site :: wordpress plugins ecommerce downloads

    ReplyDelete
  8. Thanks for your comments...

    ReplyDelete
  9. The prenatal nutritional vitamins which you purchased need to function effectively.
    As lengthy as they've iron, folic acid and calcium then they
    will aid your entire body get into what I contact "mommy mode."

    Also visit my website :: vitamin shoppe hours waterford lakes, ,

    ReplyDelete
  10. Also, i didn't really know what post to put this on but guess what?

    I get to study and review books that have not come out yet!
    I'm so excited!

    Stop by my website cheggit net

    ReplyDelete
  11. You need to participate within a contest for top-of-the-line blogs on the net.
    I will recommend this web site!

    my blog; Vbulletin software price

    ReplyDelete

Your feedback may help others !!!

Facebook comments