Allow issues grouping by creation, update and closing date (#13803).

Implemented for PostgreSQL only for now.

git-svn-id: http://svn.redmine.org/redmine/trunk@17724 e93f8b46-1217-0410-a6f0-8f06a7374b81

1 files changed, 13 insertions, 0 deletions

diff --git a/lib/redmine/database.rb b/lib/redmine/database.rb
index 02580d160..c18470a41 100644
--- a/lib/redmine/database.rb
+++ b/lib/redmine/database.rb
@@ -64,6 +64,19 @@ module Redmine
         end
       end
 
+      # Returns a SQL statement to cast a timestamp column to a date given a time zone
+      # Returns nil if not implemented for the current database
+      def timestamp_to_date(column, time_zone)
+        if postgresql?
+          if time_zone
+            identifier = ActiveSupport::TimeZone.find_tzinfo(time_zone.name).identifier
+            "(#{column}::timestamptz AT TIME ZONE '#{identifier}')::date"
+          else
+            "#{column}::date"
+          end
+        end
+      end
+
       # Resets database information
       def reset
         @postgresql_unaccent = nil