mysql - SQL stored yyyy/mm/dd to text via php/sql -

my date field saves data in following format:

2016-09-02 14:04:43

instead, i'd say:

02 september 2016, 2:04 pm

is there easy way convert using php/mysql statements?

edit: able select let's rows date in last 30 days. example, select rows date > 2017/03/06

you can use mysql function: date_format(). in case, can try:

date_format(now(),'%d %m %y %h:%i %p)

more here.

also change people have told you, make column datetime.