Update of /var/cvs/src/org/mmbase/storage/search/implementation/database
In directory 
james.mmbase.org:/tmp/cvs-serv30720/src/org/mmbase/storage/search/implementation/database

Modified Files:
      Tag: MMBase-1_8
        BasicSqlHandler.java 
Log Message:
MMB-1703


See also: 
http://cvs.mmbase.org/viewcvs/src/org/mmbase/storage/search/implementation/database
See also: http://www.mmbase.org/jira/browse/MMB-1703


Index: BasicSqlHandler.java
===================================================================
RCS file: 
/var/cvs/src/org/mmbase/storage/search/implementation/database/BasicSqlHandler.java,v
retrieving revision 1.62.2.9
retrieving revision 1.62.2.10
diff -u -b -r1.62.2.9 -r1.62.2.10
--- BasicSqlHandler.java        5 Sep 2007 08:11:52 -0000       1.62.2.9
+++ BasicSqlHandler.java        13 Aug 2008 09:01:25 -0000      1.62.2.10
@@ -23,7 +23,7 @@
  * Basic implementation.
  *
  * @author Rob van Maris
- * @version $Id: BasicSqlHandler.java,v 1.62.2.9 2007/09/05 08:11:52 michiel 
Exp $
+ * @version $Id: BasicSqlHandler.java,v 1.62.2.10 2008/08/13 09:01:25 pierre 
Exp $
  * @since MMBase-1.7
  */
 
@@ -155,9 +155,12 @@
             append(stringValue).
             append("'");
         } else if (fieldType == Field.TYPE_DATETIME) {
-            // should this not be translated to a date first??
             if (value instanceof Number) {
-                sb.append(((Number) value).longValue());
+                // first translated to a date
+                Date dateValue = new Date(((Number) value).longValue()*1000);
+                sb.append("'");
+                appendDateValue(sb, dateValue);
+                sb.append("'");
             } else {
                 sb.append("'");
                 appendDateValue(sb, (Date) value);
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs

Reply via email to