Announcement

Collapse
No announcement yet.

How does vbulletin store dates?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How does vbulletin store dates?

    I can see that the datatype is an integer but how can I convert the integer to a date in a SQL query?
    Regards - John
    Customer info in profile

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

    Comment


    • #3
      Thanks, Ed. So is there a mysql function to display the timestamp as a formated date string?
      Regards - John
      Customer info in profile

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X