Beginner questions about the date () in HP

Beginner question Date () in HP
MySQL one field is the value of the datetime type deposited 2012-02-23 09:24:40

Why Use Date (' y-m-d ', date field) to get 1970-011

How to get 2012-02-23

------Solution--------------------
Select Date_format (Date field, "%y-%m-%d") from table name
------Solution--------------------
Use the MySQL function to handle it. The date field of PHP is an integer timestamp
------Solution--------------------
The passed argument should be an int $timestamp timestamp

echo Date (' y-m-d ', strtotime (' Now '));

or directly

echo Date (' y-m-d ');

If you want to get your time in MySQL can be converted into a timestamp before converting

Date (' y-m-d ', strtotime (date field));

