mysql> select FROM_UNIXTIME(regdate/1000,'%Y %D %M %h:%i:%s %x')as date from passport_user_info where userid = 10699366 \G
*************************** 1. row ***************************
date: 2010 28th December 01:52:58 2010
1 row in set (0.00 sec)
*************************** 1. row ***************************
date: 2010 28th December 01:52:58 2010
1 row in set (0.00 sec)