You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by fr...@apache.org on 2009/07/25 11:07:03 UTC

svn commit: r797723 - /incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/derby/DBDatabaseDriverDerby.java

Author: francisdb
Date: Sat Jul 25 09:07:03 2009
New Revision: 797723

URL: http://svn.apache.org/viewvc?rev=797723&view=rev
Log:
EMPIREDB-46
datetime-phrase issue in DBDatabaseDriverDerby

Modified:
    incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/derby/DBDatabaseDriverDerby.java

Modified: incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/derby/DBDatabaseDriverDerby.java
URL: http://svn.apache.org/viewvc/incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/derby/DBDatabaseDriverDerby.java?rev=797723&r1=797722&r2=797723&view=diff
==============================================================================
--- incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/derby/DBDatabaseDriverDerby.java (original)
+++ incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/derby/DBDatabaseDriverDerby.java Sat Jul 25 09:07:03 2009
@@ -192,7 +192,7 @@
             case SQL_CURRENT_DATE:            return "CURRENT_DATE()";
             case SQL_DATE_PATTERN:            return "yyyy-MM-dd";
             case SQL_DATE_TEMPLATE:           return "'{0}'";
-            case SQL_CURRENT_DATETIME:        return "NOW()";
+            case SQL_CURRENT_DATETIME:        return "CURRENT_TIMESTAMP";
             case SQL_DATETIME_PATTERN:        return "yyyy-MM-dd HH:mm:ss";
             case SQL_DATETIME_TEMPLATE:       return "'{0}'";
             // functions