SELECT DATE_FORMAT(posttime, "%d.%m.%Y, %T:") AS posttime, .... FROM table