How to get hours and min

Hi ,I have column in table renewdate, the datatype for this is DATETIME ,how can I populate the date to remove the seconds ? only to show this
2015-07-30 08:00

Thank you in advance.

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


1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.