从MYSQL表中提取没有时间的日期[复制]

Question

This question already has an answer here:

• PHP: formatting a date from mySQL to be date only 3 answers

I am using the followup procedure to display date from mysql tabe:

<? echo $rrow[encoded_date]; ?>

Now the format of encoded_date cell is: 2013-03-20 01:52:39 .

My question is how to extract only the date without the time.

</div>

Answer 1

You can do it with PHP:

$yourDateTime = "2013-03-20 01:52:39";
date('Y-m-d', strtotime($yourDateTime));