Code Forums - View Single Post - Problems in date DESC after changing format

bayruni · 04-01-2006, 09:02 PM

I get January 01, 1970, 03:00:00 AM as my date...
Other than adding this code and editing my table names and such, is there anything I need to do in CocoaMySQL? Should I change my article_date column to show timestamp instead of datetime?

And, how will this unix timestamp fix the order of articles (my main problem)?

Edit:
I found that if I display the date as 04/02/06 along with the time, my problem is solved and articles are arranged correctly by date. But I don't want the 04. I want it to show April instead.

04-01-2006, 09:02 PM	#3 (permalink)
bayruni Registered User Join Date: Mar 2006 Posts: 9	I get January 01, 1970, 03:00:00 AM as my date... Other than adding this code and editing my table names and such, is there anything I need to do in CocoaMySQL? Should I change my article_date column to show timestamp instead of datetime? And, how will this unix timestamp fix the order of articles (my main problem)? Edit: I found that if I display the date as 04/02/06 along with the time, my problem is solved and articles are arranged correctly by date. But I don't want the 04. I want it to show April instead.