Ticket #1 (closed defect: fixed)

Opened 10 months ago

Last modified 8 months ago

Store dates in GMT

Reported by: john Assigned to: enobrev
Priority: major Milestone:
Component: database Version:
Keywords: Cc:

Description

They're stored by local time zone now - lame.

Attachments

gmt_timezones.diff (31.2 kB) - added by enobrev on 03/04/08 12:18:47.
Patch to store as GMT +0:00 and alow user / server timezones

Change History

02/04/08 14:37:32 changed by john

  • owner changed from somebody to john.

03/03/08 21:01:42 changed by enobrev

  • owner changed from john to enobrev.
  • status changed from new to assigned.

Patch allows admin to set server timezone and users to set their timezones

Patch then inserts new posts as GMT +0:00 and retrieves them at the user's stored timezone (defaults to server timezone if none set).

Includes update to install.sql (new timezone field in users table and new conf row site.tz)

03/03/08 21:48:50 changed by enobrev

Just realized the mysql function convert_tz, which is what I'm using to convert dates, was added as of MySql? 4.1.3. Do we have a baseline version for MySql??

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_convert-tz

03/04/08 12:18:47 changed by enobrev

  • attachment gmt_timezones.diff added.

Patch to store as GMT +0:00 and alow user / server timezones

03/10/08 03:53:16 changed by enobrev

  • status changed from assigned to closed.
  • resolution set to fixed.

Resolved in changeset [34]

03/22/08 03:59:32 changed by anonymous

baidu 163 sina beiing hotel hotel ???4 star hotel2 star hotel

3 star hotel

5 star hotelwrought iron stair railings stair railings outdoor stair railings aluminum stair railing wrought iron stair baluster wrought iron stair railing parts staircase handrail iron stair rails interior metal staircase

wood stair railings call center 4007 sell water

Add/Change #1 (Store dates in GMT)




Change Properties
Action