dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Selecting date range

  1. #1
    Join Date
    Sep 2010
    Posts
    22

    Selecting date range

    I'm trying to select a range of dates, something like:

    select * from table where dateColumn between currentDate and currentDate - 35

    Any hints? Thanks!

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    21,443
    Should work in MySQL, not 100% sure about other DBMS's:
    Code:
    SELECT * FROM table_name WHERE date_column BETWEEN CURDATE() AND DATE_ADD(CURDATE, INTERVAL 25 DAY)
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles