php - Mysql select - Get the dates of timestamps -

In mysql table, the stored value of timestamp (eg 1265138145) What do I want to display the date (like 27/2/2011 , 10/3/2011, 15 / 3/2011, 16/03/2011 etc.) are related to these timestamps. Is this possible? (But display only a time date, for example if 1265138145 and 1265138140 then display only the date only once - which is 16/3)

For example: SELECT FROM_UNIXTIME (& lt; timestamp field & gt;, '% d /% m /% y');

I do not believe what it means about "display only the date only once," but the required column should help on DISTINCT .

i.e .:: SELECT DISTINCT (FROM_UNIXTIME (timestamp field>, '% d /% m /% Y')); Required.