Some Mysql Query Help


EvilDragon

Administrator
Staff member
Joined
Mar 4, 2003
Messages
29,986
Age
46
Location
Ingolstadt
Some may have noticed, I added RSS Feed to the GP32x File Archive.

Though it works fine, there's just one problem: The dates of the files in the aren't working correctly.

I also do know why: They are stored as TIMESTAMP in the MySQL-Database, but the RSS doesn't understand that.

I'm reading the database with this query:

Code:
SELECT title AS Title,
catid as Catlink,
id AS Link, 
description AS Description,
fdate AS Date,
author AS Author
FROM gp32_files 
ORDER BY fdate DESC LIMIT 20

fdate is the column which has the TIMESTAMP date stored.

How can I tell MySQL, that I want that date as normal date?

Thanks for any help :)
 
Back
Top