mysql query to fetch record between a specific date

Question

I want to fetch the records from database from a specific date. I have a columns log_date having datetime data type. now I want to get all records which have log date of previous 24 hours.

Markus Hedlund · Accepted Answer · 2011-05-02 07:25:54Z

2

WHERE log_date BETWEEN DATE_SUB(NOW(), INTERVAL 24 HOUR) AND NOW()

I think that should work, untested though.

answered May 2, 2011 at 7:25

Markus Hedlund

24.4k22 gold badges82 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tm Cls · Accepted Answer · 2011-05-02 07:32:35Z

2

SELECT * FROM `logtable` WHERE `log_date` > DATE_SUB(NOW(), INTERVAL 24 HOUR)

edited May 2, 2011 at 7:32

answered May 2, 2011 at 7:26

Tm Cls

1,3011 gold badge9 silver badges13 bronze badges

Comments

Ruben · Accepted Answer · 2011-05-02 07:43:01Z

2

You could use the BETWEEN statement. If you google on that you will find what you are looking for.

edited May 2, 2011 at 7:43

answered May 2, 2011 at 7:20

Ruben

6992 gold badges16 silver badges36 bronze badges

Collectives™ on Stack Overflow

mysql query to fetch record between a specific date

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related