How to display todays records from mysql table having name as varchar and date as datetime?

0 ⤊

2006-08-11 08:21:08 · 3 answers · asked by Mohammad Shahid 1 in Computers & Internet ➔ Programming & Design

SELECT * FROM table WHERE substring( date,1,10 ) = CURDATE(); should work.

2006-08-11 09:27:29 · answer #1 · answered by John J 6 · 0⤊ 0⤋

SELECT * FROM yourtablename WHERE datetime = todays dat in the format you specified in the table when creating it

2006-08-11 08:24:12 · answer #2 · answered by Dragosh 3 · 0⤊ 1⤋

SELECT * FROM table WHERE date>2006-08-11

2006-08-11 08:23:36 · answer #3 · answered by ronald t 2 · 0⤊ 2⤋