Archiving: posterTime in regular date format

[NV]

Hi,

to keep my database size low, I want to delete topics from my board and offer them as simple html pages to my forum members.

With phpmyadmin I want to export these topics and created a sql statement which looks for example like this:

SELECT `ID_TOPIC` , `subject` , `posterName` , `posterTime` , `body`
FROM `messages`
WHERE 1 AND `ID_TOPIC` = 349
ORDER BY `posterTime` ASC

the only problem I have is the field 'Postertime' (Unix timestamp). In the final output I want it to appear like a regular date format, like dd-mm-yy.

can anybody hint me how to adjust the sql statement so that it works?

Thanks in advance.

[[Unknown]]

SELECT `ID_TOPIC`, `subject`, `posterName`, FROM_UNIXTIME(`posterTime`, '%M %D, %Y, %h:%i:%s %p'), `body`
FROM `messages`
WHERE `ID_TOPIC` = 349
ORDER BY `posterTime` ASC

-[Unknown]

[NV]

Thanks!