Log in

View Full Version : A little technical question in vBulletin


Ahmed_Eissa
07-17-2007, 12:27 PM
Hi,

A little technical question in vBulletin:

I just add a thread today in vBulletin to try it, and when I check it in my browser (IE 6) it view the date correctly:

17th July 2007 13:33

But in the forum database it's stored like this:

1184669495

Please could anybody tell me please the way which is used to store the date in vBulletin and it's database?

Thank you,

Best regards,

Ahmed Eissa.

EnIgMa1234
07-17-2007, 12:34 PM
It is stored using the UNIX timestamp.

So when that message was posted TIMENOW was used
The numbers represents the number of seconds from a specific date (Jan. 1st 1970 I think)

When it is pulled from the database it is parsed like this

vbdate($vbulletin->options['dateformat'], $somevariable]);

Hope that answers your question

Dismounted
07-20-2007, 12:12 PM
The numbers represents the number of seconds from a specific date (Jan. 1st 1970 I think)
Yes, that is correct, it is also commonly referred to as the Unix Epoch (http://en.wikipedia.org/wiki/Unix_time).