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?

*(reference)* Date and Time Functions in MySql: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_curdate and PHP Date Function: http://de.php.net/manual/en/function.date.php — Gordon, May 13 '10 at 18:12

score 56 · Accepted Answer · edited Oct 16 '19 at 12:47

56

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));

edited Oct 16 '19 at 12:47

Flimm

136,138
45
251
267

answered May 13 '10 at 18:02

Sarfraz

377,238
77
533
578

What if for selected timezone like Philippines, how do I implement that one? – RoCkDevstack Jun 23 '16 at 11:29

score 3 · Answer 2 · answered May 13 '10 at 18:01

3

date("Y-m-d") should give you the current date in that format.

answered May 13 '10 at 18:01

Mitch Dempsey

38,725
6
68
74

score 0 · Answer 3 · answered May 13 '10 at 18:02

0

SELECT CURDATE();

answered May 13 '10 at 18:02

Jon

428,835
81
738
806

score 0 · Answer 4 · answered May 13 '10 at 18:04

The function I think you are looking for is

$datetime = strtotime($MySQLDateResponse);

$MySQLDatResponse being the date you get back from MySQL. This will give you a PHP time stamp. You can then convert that timestamp into any date format you want. For the one you listed it's

date("Y-m-d", $datetime);

Hope that helps

MKTIME, PHP date/timestamp YYYY-MM-DD

4 Answers4