convert JOIN DATE in the vB mysql database to a real date

[Quarterbore]

Is there an easy way to convert JOIN DATE in the vB mysql database to a real date?

Can anyone explain what that code really means? I have a site that is at it's 1st year and I wanted to share the stats for the year with my members but the code has me puzzled!

[tnguy3n]

vB dateline = time(), time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT).

If you want to convert it real date (i.e, mm-dd-yyyy), try

UPDATE user SET joindate = date('m-d-Y', joindate)

[Dean C]

Whatever you do, don't change it. Learn how to use time properly (www.php.net/time)

[Paul M]

Originally Posted by tnguy3n

vB dateline = time(), time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT).

If you want to convert it real date (i.e, mm-dd-yyyy), try

UPDATE user SET joindate = date('m-d-Y', joindate)

That would be a very bad thing to do, and probably fail anyway since joindate is an integer field.

[sabret00the]

Originally Posted by Dean C

Whatever you do, don't change it. Learn how to use time properly (www.php.net/time)

lol, but i agree, it's insane to want to dump the timestamps