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