select date_format(time,"%d %m %Y %T") as time, .....