How does vbulletin store dates?

[JohnL]

I can see that the datatype is an integer but how can I convert the integer to a date in a SQL query?

[Mike Sullivan]

It's a unix timestamp -- MySQL supports switching to and from it. And it's PHP's native format for date().

[JohnL]

Thanks, Ed. So is there a mysql function to display the timestamp as a formated date string?