1. 06-23-11 10:11 AM #1
    jolmscheid
    jolmscheid's Avatar Become A Pro!
    Join Date: 02-20-10
    Posts: 3,256
    Betpoints: 0

    How to Query this in Sports Data Base?

    Hey guys, I am needing some help just on how to query AFTER or BEFORE a certain date...for instance if I want to see the stats after the 1st month of the season, or after the all-star break, etc...

    Anyone out there that could help me with this query? It would be much appreciated!
    Reply With Quote Reply With Quote
  2. 06-23-11 11:03 AM #2
    jgilmartin
    jgilmartin's Avatar Become A Pro!
    Join Date: 03-31-09
    Posts: 1,119
    Betpoints: 7

    I think you would have to do each year separately, but this worked:

    date>20100701 and date<20100704

    This showed games from July 2, 2010 and July 3, 2010
    Reply With Quote Reply With Quote
  3. 06-23-11 12:59 PM #3
    jolmscheid
    jolmscheid's Avatar Become A Pro!
    Join Date: 02-20-10
    Posts: 3,256
    Betpoints: 0

    Perfect...thank you very much jgilmartin..
    Reply With Quote Reply With Quote
  4. 07-01-11 10:18 AM #4
    eldian
    eldian's Avatar Become A Pro!
    Join Date: 09-23-10
    Posts: 180
    Betpoints: 1062

    how do i query range in sdb, like opening line of +100-+109?
    Reply With Quote Reply With Quote
  5. 07-01-11 01:39 PM #5
    EasyHustlin
    EasyHustlin's Avatar Become A Pro!
    Join Date: 07-15-10
    Posts: 633
    Betpoints: 234

    Quote Originally Posted by eldian View Post
    how do i query range in sdb, like opening line of +100-+109?
    Line>100 and line<109
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »