Page 1 of 1

mysql - yesterday's date

Posted: Mon Dec 01, 2003 3:26 am
by patejl
hey all,
just simple question for you :)

how to obtain yesterday's date? i want select all yesterday's operation from table. is it better to prepare it by php or by mysql select statement?

best
patejl

Posted: Mon Dec 01, 2003 4:18 am
by Weirdan
select date_format(now()-interval 1 day,'%Y%m%d');