I have a column in a table which is epoch time including milliseconds.

e.g. = 1409304102153


now i want to display all fields in the table but this field as: "2014-8-29 Fri 09:21:42:xxxx GMT" (whatever comes in xxxx)


and i am not finding anything on web about how to do that.

can anyone help please.

ty.
Rajeev

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql