求一mysql sql语句

Question

mysql数据库里面有一表A  表A里有一字段field_date 
表A里只有一行记录 该记录里字段field_date的值为1258943275现在求一sql查询语句 查出该行记录 并将field_date 查询出的时间格式转换为(2012-05-08)这样的格式谢谢

Answer 1

mysql>  select  from_UNIXTIME(1258943275);
+---------------------------+
| from_UNIXTIME(1258943275) |
+---------------------------+
| 2009-11-23 10:27:55       |
+---------------------------+
1 row in set (0.02 sec)

Answer 2

mysql> select from_unixtime(1258943275);
+---------------------------+
| from_unixtime(1258943275) |
+---------------------------+
| 2009-11-23 10:27:55       |
+---------------------------+
1 row in set (0.02 sec)

Answer 3

select  from_UNIXTIME(field_date) FROM TT;

Answer 4

select  date(from_UNIXTIME(field_date)) FROM TT;

Answer 5

select  date(from_UNIXTIME(1258943275));
select  date_format(from_UNIXTIME(1258943275),'%Y-%m-%d');

Answer 6

select DATE(FROM_UNIXTIME(1258943275));