How to Fetch data related to current date from data base with date Time

Question

My database date column format is (16/06/2019 8:33 AM). How can I fetch data based on current date only.

SELECT * FROM `table` WHERE date_column = CURDATE()

So you have to convert the text to a date first. But you should not store dates as text. Use an date column to store dates. — Jens, Jun 16 '19 at 07:44
@Jens i changed data type of date_column date, But its still not working. trying with bellow answer. — Dishko, Jun 16 '19 at 07:49
@Jens oh sorry that's why all my date-column is blank now, And its not inserting date format like 16/06/2019 8:33 AM, I am trying to insert it with `date('d/m/Y g:i A');` — Dishko, Jun 16 '19 at 07:53
You have to convert your string to date first with https://stackoverflow.com/questions/5201383/how-to-convert-a-string-to-date-in-mysql — Juan Carlos Oropeza, Jun 16 '19 at 10:33

score 1 · Accepted Answer · edited Jun 16 '19 at 07:46

1

SELECT * 
FROM `table` 
WHERE DATE(date_column) = CURDATE()

edited Jun 16 '19 at 07:46

Jens

answered Jun 16 '19 at 07:35

1 Answers1