MySQL query value where current date

Question

What is the proper way to query all data on current date? a function in mysql that will get the current date in 12:01 am and current date 11:59 pm

select * from tb_data where date between currentdate_starts and currentdate_ends

` DATE(column) = CURDATE()` is a performance killer – user2095165 Jan 02 '14 at 05:08 — user2095165, Jan 02 '14 at 05:08

score 5 · Answer 1 · edited May 23 '17 at 11:43

5

Without using DATE(column) = CURDATE()

   SELECT * FROM tb_data WHERE date between concat(curdate(),' ','00:00:00') AND concat(curdate(),' ','23:59:59')

edited May 23 '17 at 11:43

Community

answered Jan 02 '14 at 05:15

Ukkin

Surabhil Sergy · Accepted Answer · 2014-01-02T05:21:49.323

4

Try using CURDATE()

SELECT field FROM table WHERE DATE(column) = CURDATE()


select * from tb_data where DATE(date) = CURDATE()

Documentation: CURDATE

edited Jan 02 '14 at 05:21

answered Jan 02 '14 at 05:04

Surabhil Sergy

score 2 · Answer 3 · answered Jan 02 '14 at 05:04

2

CURDATE() returns the current date.

SELECT * from FROM tb_data WHERE DATE(column) = CURDATE()

answered Jan 02 '14 at 05:04

Nagaraj S

score 2 · Answer 4 · answered Jan 02 '14 at 05:05

2

Try this:

SELECT * FROM tb_data WHERE DATE(dateCol) = CURRENT_DATE();

OR

SELECT * FROM tb_data WHERE DATE(dateCol) = CURDATE()

answered Jan 02 '14 at 05:05

Saharsh Shah

score 2 · Answer 5 · answered Jan 02 '14 at 05:21

2

well since there are so many answers. Try this one too and see if it's faster

SELECT * FROM tb_data WHERE date BETWEEN CURDATE() AND (CURDATE()+INTERVAL 1 DAY-INTERVAL 1 SECOND)

answered Jan 02 '14 at 05:21

Tin Tran

5 Answers5