Re: GMT Offset
bb_current_time is in the functions file inside bb-includes directory. But you probably should touch that otherwise when you update bbpress, it will break again.
The SQL I used was just an interval clause…i.e. if I was going to import my current forums I would use something like:
SELECT ID, Body, DateCreated – interval ‘9 30’ hour_minute FROM current_forum_whatever
This takes the date field and drops 9.5 hours off, coincidentally, my time zone.
You could probably adapt this to an ‘update’ statement to change what’s already in your database, eg:
UPDATE bb_topics SET DateCreated=(SELECT DateCreated – interval ‘9 30’ hour_minute);
I haven’t tested it but it probably wouldn’t be too far wrong.