How to get hours and min

Databases
1

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.

2

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

:slight_smile:

1 Like
3

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