From b7198c1980800a2473bcbc6232b03536f4bc01f8 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Tue, 11 Sep 2012 10:23:29 +0200 Subject: [PATCH] SONAR-3542 fix the DATE type on Oracle --- .../lib/arjdbc/oracle/adapter.rb | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sonar-server/src/main/webapp/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/oracle/adapter.rb b/sonar-server/src/main/webapp/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/oracle/adapter.rb index c27a4f2d714..3486a58887b 100644 --- a/sonar-server/src/main/webapp/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/oracle/adapter.rb +++ b/sonar-server/src/main/webapp/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/oracle/adapter.rb @@ -382,7 +382,9 @@ module ::ArJdbc end quoted = super #sonar - if value.acts_like?(:date) || value.acts_like?(:time) || value.acts_like?(:timestamp) + if value.acts_like?(:date) + quoted = "TO_DATE('#{value.strftime('%Y-%m-%d')}','YYYY-MM-DD')" + elsif value.acts_like?(:time) || value.acts_like?(:timestamp) quoted = "TO_TIMESTAMP('#{value.strftime('%Y-%m-%d %H:%M:%S')}:#{("%.6f"%value.to_f).split('.')[1]}','YYYY-MM-DD HH24:MI:SS:FF6')" end #/sonar -- 2.39.5