Date Converting mysql

[Kuscheltod]

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]

Originally Posted by Kuscheltod

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 or the vbulletin dbdate() function to build dates according to user preferences.