Date query

Discussion in 'Databases' started by Solomoncandy, Jul 3, 2015.

0
  1. #1
    I need to extract the details from today until 6 previous days from the table. Can you help me to form this query?
     
    Solomoncandy, Jul 3, 2015 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    Well, as long as you have a properly formatted date-column, something like "SELECT * FROM tablename WHERE date_column >= date_sub(now(), interval 6 days)" or something like that.
     
    PoPSiCLe, Jul 3, 2015 IP
  3. Taruna P

    Taruna P Greenhorn

    Messages:
    13
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    13
    #3
    SELECT * FROM table WHERE date >= curdate()- INTERVAL DAYOFWEEK(curdate())+6 DAY AND date < curdate()- INTERVAL DAYOFWEEK(curdate())-1 DAY
     
    Taruna P, Jul 6, 2015 IP
  4. Solomoncandy

    Solomoncandy Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    Thanks
     
    Solomoncandy, Jul 17, 2015 IP
  5. SalvadorWilliam

    SalvadorWilliam Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #5
    you can perform following querry for the extraction of details
    select from table_name where column_name < DATE_SUB(NOW(), INTERVAL 6 DAY)
     
    SalvadorWilliam, Jul 24, 2015 IP