MKTIME, PHP date/timestamp YYYY-MM-DD

Question

I need to query MySQL for the current date (from PHP) in YYYY-MM-DD format... anyone?

Answer 1

MySQL curdate:

You can do in query:

select curdate()

PHP date

echo date('Y-m-d');

If you want to pass your own date format:

echo date('Y-m-d', strtotime($your_date));