convert 10 digit timestamp to readable format in mysql

SELECT * , UNIX_TIME(

submitdate

)


You should use  UNIX_TIME() function in mysql to convert timestamp to readable form