← Back to team overview

phpns-team team mailing list archive

[Question #47756]: timestamp problem

 

New question #47756 on phpns:
https://answers.launchpad.net/phpns/+question/47756

I want to create an archive box that allow you to browse articles by month/year. However I am having problem extracting the date from the timestamp column as it is a varchar rather than an actually timestamp, so basically I don't know how to convert the timestamp to readable date. I also want it to be converted in a MySQL query so I can compare the date with another variable.

Thanks.

-- 
You received this question notification because you are a member of
Phpns-team, which is an answer contact for phpns.