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:
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
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