phpns

timestamp problem

Asked by blame

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.

Question information

Language:
English Edit question
Status:
Answered
For:
phpns Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
alecwh (alecwh) said : 		#1

How are you having trouble extracting the date? What language are you
using to do it? PHP should just let you grab the string, and you can
easily convert it with built-in functions... Well, you are correct, it
is a VARCHAR instead of a timestamp.

Anyway, this really isn't a question regarding phpns, rather a question
regarding database manipulation.

Can you help with this problem?

Provide an answer of your own, or ask blame for more information if necessary.

To post a message you must log in.