How to format timestamp to date?

Question

MySQL

If I request the value of a timestamp field using "SELECT date FROM entries WHERE id=n", I get the format string yyyy-mm-dd hh-ii-ss , but I need to get only yyyy-mm-dd . Prompt the query string.

Answer 1

date_format(registration, '%Y-%m-%d')
dev.mysql.com/doc/refman/5.5/en/date-and-time-func...
PS DATE_FORMAT
(FROM_UNIXTIME(`date `), ' %Y-%m-%d') as "Date" FROM `entries `
should work for your case.