I've tried using 

FROM_UNIXTIME(`date`)

and got a yyyy/mm/dd hour

how can I reverse it, that is have it as

hh:mm:secs mm/dd/yyyy

Thanks

mysql sql date datetime datetime-format
Edit
Report