PDA

View Full Version : Date Converting mysql


Kuscheltod
09-14-2010, 09:48 PM
Hey,

right now I'm setting up some e-mail marketing schedules from my userdatabase.

For this I would like to focus on some activity-parts.

Now I would like to know how I can calculate dates out of the row f.e. lastpost 1284476315.

Thanks a lot in advance!

Kind regards

compwhizii
09-15-2010, 01:47 AM
Hey,

right now I'm setting up some e-mail marketing schedules from my userdatabase.

For this I would like to focus on some activity-parts.

Now I would like to know how I can calculate dates out of the row f.e. lastpost 1284476315.

Thanks a lot in advance!

Kind regards

That is a UNIX timestamp. You can read up on it here: http://en.wikipedia.org/wiki/Unix_time

You can use the php date() function (http://php.net/manual/en/function.date.php) or the vbulletin dbdate() function (http://members.vbulletin.com/api/vBulletin/_includes---functions.php.html#functionvbdate) to build dates according to user preferences.