Read further if you are getting dates far away into the future (2033).
If you want to get a Timestamp (20020231164333 format) from a mysql
database and format it into a readable output, use this command on your
mySQL query,
assuming you have something like
SELECT lastaccesstime FROM user WHERE userid= 'hecky';
change it to
SELECT date_format(lastaccesstime, '%M %e, %Y') FROM user WHERE userid =
'hecky';
this will format the date to a Month, date year.
the % options should be the same as PHP ones, %M = month, %i = minutes, %Y
= year , etc.
As with PHP's date() function you customize the format.
eg
'Year is %Y, and month is %M'
=Year is 2002,and month is February
