I tried UNIX_TIMESTAMP(dateline) but that doesnt work, anyone know?
dateline field in threadid - what format is it?
Collapse
X
-
The dateline column in the post table is in Unix timestamp format, which is the number of seconds since midnight Jan. 1, 1970. You can use this online tool to convert Unix Timestamps to date and time:
Or to change the date on a thread:
update thread set dateline = UNIX_TIMESTAMP ('YYYY-MM-DD') where threadid = 'xxx'Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment