Convert Data Field to Real Date

[CypherSTL]

Currently I have date fields in my database that just read: 1216276261

I have an external script that pulls information form the vBulletin Databases so using the vB Datamangers is not an option.

Can anyone point me in the right direction on how to convert that into a real date?

Thanks.

[Opserty]

<a href="http://php.net/date" target="_blank">http://php.net/date</a>

[CypherSTL]

Originally Posted by Opserty

http://php.net/date

Been reading that article for a while before I posted here. I'm kinda stuck atm.

[Opserty]

What is your current code?

PHP Code:

// $datedata holds the "dateline" e.g. the "1216276261"

// Prints something like: Monday 8th of August 2005 03:12:46 PM
echo date('l jS \of F Y h:i:s A', $datedata); 


[CypherSTL]

Originally Posted by Opserty

What is your current code?

PHP Code:

// $datedata holds the "dateline" e.g. the "1216276261"

// Prints something like: Monday 8th of August 2005 03:12:46 PM
echo date('l jS \of F Y h:i:s A', $datedata); 


Thanks man. That worked. I had '$datedata' and I was getting errors. Removed the '' and all is good!

Thanks.

[Dismounted]

In vBulletin, you should use vbdate() instead of date(). See the API Documentation.

[Opserty]

I have an external script that pulls information form the vBulletin Databases so using the vB Datamangers is not an option.

(Damn vBulletin character count...).

[Dismounted]

I was just meaning to say if.