How to get hours and min

[jemz]

Solved it by using DATE_FORMAT(columnfield,‘%Y-%m-%d %H:%i’) as “formatted_date”