UTC Time in the Database

I wonder if it's possible to put "post_time" into the database as UTC (ie, GMT) instead of the server local time. I should think it would be, as the sever can certainly give the time as UTC. I know it's possible to adjust the displayed time on the page but I would like to have UTC in the database to avoid problems with "daylight saving" etc.

Can you give me any clues on how to investigate this? Where in MiniBB code is the time put into the database?

Thanks

Actually, I don't know what "daylight saving" problem could be - if you mean that you need to insert user's time, not server time, than this is probably not the best idea... Somebody can make a post in US, and then somebody can answer in Europe - and his answer could be "earlier". Actually, you need to change some requests in setup_mysql module, inserting not "now()" statement, but making JavaScript time on the page and posting it somewhere as hidden field.

By "daylight saving problem" I mean when the server goes to local "summer time" on a different day from the timezone the forum is using.

I definetely do not mean to insert user's time, I mean to insert UTC - for every post.

Anyway, thanks for your answer, I'll have to do some research and see if there is a UTC version of now().

here's a page with some interesting information. Would I have to replace every instance of NOW() with UTC_DATE() and UTC_TIME()? If so, what would the syntax be?

should be like: DATETIME('UTC_DATE() UTC_TIME()') instead of single now() then. you can try ;) i think it works only in newest mysql versions, won't work in older ones..

Still, we don't recommend to change anything. miniBB has all internal routines for handling time zones for specific users; the date format we use is the universal one. It works on all systems.

Thanks very much. I'll try it.