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

Modified Files:
        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.75
retrieving revision 1.76
diff -u -b -r1.75 -r1.76
--- BasicSqlHandler.java        17 Jul 2008 12:55:23 -0000      1.75
+++ BasicSqlHandler.java        13 Aug 2008 09:02:00 -0000      1.76
@@ -23,7 +23,7 @@
  * Basic implementation.
  *
  * @author Rob van Maris
- * @version $Id: BasicSqlHandler.java,v 1.75 2008/07/17 12:55:23 michiel Exp $
+ * @version $Id: BasicSqlHandler.java,v 1.76 2008/08/13 09:02:00 pierre Exp $
  * @since MMBase-1.7
  */
 
@@ -156,9 +156,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