[Klorinsky]

CREATE TABLE foobar (
id int(255) auto_increment,
time timestamp,
PRIMARY KEY (id)
);

SELECT DATE_FORMAT(time, '%y-%m-%d %H:%i:%s') AS time from foobar;