Tags
MySQL , Sql , DATE
Asked 7 years ago
17 Jul 2017
Views 1172

posted

find record which one day before from now MySQL ?

find record which one day before from now MySQL ?

Mitul Dabhi

Mitul Dabhi
answered Nov 30 '-1 00:00 


`field_name`<DATE_SUB(NOW(), INTERVAL 1 DAY)


here field_name should be date or datetime type


Edit Answer
Post Answer
OMG!   You need to Login / Register to Post Answer
[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic