Converting epoch to h:mm within MySQL Query
Posted on 2012-03-31
Simply query starts like...
SELECT apps_zapata_walks.id, apps_zapata_walks.walker_fname, apps_zapata_walks.walker_lname, apps_zapata_walks.walker_email, mdl_user.firstname as TeacherFirstName, mdl_user.lastname as TeacherLastName, mdl_user.email as TeacherEmail, mdl_groups.`name` as CampusName, apps_zapata_walks.co_teacher, apps_zapata_walks.date_of_walk, apps_zapata_walks.auto_time_in, apps_zapata_walks.auto_time_out,
How can I format the apps_zapata_walks.auto_time_in as hh:m within the query?
Of course I doubt that would work but I am having trouble finding out what will.
Thank you in advance!