Working with days

redstarfcs · #1 (**permalink**) 08-15-2004, 04:49 AM

Hi,

I have a database where I insert datas everyday. Does MySQL has a command which let me select all the datas that were inserted the day before?

Ex. If I run today the query, the databases shows all the datas from yesterday.

mushroom · #2 (**permalink**) 08-15-2004, 12:23 PM

It will depend on the date and time column type you are using (date, time, datetime, timestamp )

The php funtion "date("Ymd"); will give you todays date.

ronniethedodger · #3 (**permalink**) 08-16-2004, 12:49 PM

redstarfcs, I am not sure what language you speak but PHP has documentation for their commands here http://www.php.net/docs.php. You will find a lot of the answers for the php functions you will need to use after you select your data from the MySQL database.

The date and time functions in question are at http://www.php.net/manual/en/ref.datetime.php for more information on those.

The MySQL manual is at http://dev.mysql.com/doc/mysql/en/index.html. Their date and time functions are at http://dev.mysql.com/doc/mysql/en/Da...functions.html