将CURRENT_TIMESTAMP转换为仅Y-m-d [复制]

Question

This question already has an answer here:

• Convert date format yyyy-mm-dd => dd-mm-yyyy 14 answers

I have a column named "timestamp" in my DB with datatype timestamp and standard CURRENT_TIMESTAMP.

When I echo it (echo $row['timestamp'];) i get this:

2016-01-18 21:06:37 
2016-01-19 12:32:16 
2016-01-19 20:52:41

But I want it to turn out like this:

2016-01-18
2016-01-19
2016-01-19

How should I do that? Strftime or something?

</div>

Answer 1

Use substr:

substr($row['timestamp'],0,10)

This will output the first 10 characters of your string.