Doctrine 2 - ORM

Tell Doctrine2 to force a timezone for a date or datetime column

Details

  • Type: New Feature New Feature
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Won't Fix
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: ORM
  • Security Level: All
  • Labels:
    None

Description

I'm working on a project that will live on multiple servers in multiple time zones and it would be great if I could tell Doctrine2, either through mappings or some other means, that all dates going into the DB should be normalized to a given time zone (such as GMT) and then be changed back to the servers local time on select. This can be accomplished using events right now but might be useful for other people in the same boat as me.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Steven Surowiec added a comment -

Attached is a sample DateTimeType class I modified to do this. This is a quick, dirty, solution but illustrates the idea.

Show
Steven Surowiec added a comment - Attached is a sample DateTimeType class I modified to do this. This is a quick, dirty, solution but illustrates the idea.
Hide
Permalink
Benjamin Eberlei added a comment -

We won't change the current behaviour since its the 95% use-case.

In your case, you could either:

1. set the timezone on all servers to GMT/UTC using the PHP Ini variable "date.timezone"
2. Implement your own DateTime types on top of the existing ones
3. Use a Database that can handle timezones correctly (Postgresql)

Show
Benjamin Eberlei added a comment - We won't change the current behaviour since its the 95% use-case. In your case, you could either: 1. set the timezone on all servers to GMT/UTC using the PHP Ini variable "date.timezone" 2. Implement your own DateTime types on top of the existing ones 3. Use a Database that can handle timezones correctly (Postgresql)
Hide
Permalink
Bernhard Schussek added a comment -

Benjamin, could you give more information about the 95%? I'm trying to understand this issue a bit better, but fail to see the many use cases for the current behavior.

Show
Bernhard Schussek added a comment - Benjamin, could you give more information about the 95%? I'm trying to understand this issue a bit better, but fail to see the many use cases for the current behavior.

People

  • Assignee:
    Roman S. Borschel
    Reporter:
    Steven Surowiec
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: