Thread: mysql now() ??
View Single Post
Old 11-17-2005, 10:13 AM   #2 (permalink)
susanh
Junior Member
 
Join Date: Jun 2005
Posts: 29
Default

You should use: NOW() - INTERVAL 1 DAY

NOW() returns the current date and time. To get the current date, you can use CURDATE() .
susanh is offline   Reply With Quote
Sponsored Links