1 PHP[ | ]
PHP
Copy
echo date('Y-m-d', strtotime('2016-02-22 00:00:00'));
# 2016-02-22
PHP
Copy
echo date('Y-m-d', strtotime('2016-02-22 23:59:59'));
# 2016-02-22
2 SQL[ | ]
2.1 MySQL[ | ]
MySQL
Copy
SELECT DATE('2016-02-22 00:00:00');
# 2016-02-22
MySQL
Copy
SELECT DATE('2016-02-22 23:59:59');
# 2016-02-22