Changeset 17869 for trunk/psLib/src/db/psDB.c

Timestamp:

May 30, 2008, 2:42:35 PM (18 years ago)

Author:

jhoblitt

Message:

handle timestamp fields as DATETIME/psTime fields

File:

• trunk/psLib/src/db/psDB.c (modified) (2 diffs)

trunk/psLib/src/db/psDB.c

@@ -23 +23 @@
  * 4.1.2 or newer is required.
  *
- * $Id: psDB.c,v 1.158 2008-05-29 21:05:50 jhoblitt Exp $
+ * $Id: psDB.c,v 1.159 2008-05-31 00:42:35 jhoblitt Exp $
  */
 
@@ -2506 +2506 @@
         psDBAddToLookupTable(mysqlToSqlLookupTable, MYSQL_TYPE_FLOAT,     "FLOAT");
         psDBAddToLookupTable(mysqlToSqlLookupTable, MYSQL_TYPE_DOUBLE,    "DOUBLE");
-        psDBAddToLookupTable(mysqlToSqlLookupTable, MYSQL_TYPE_TIMESTAMP, "TIMESTAMP");
+        psDBAddToLookupTable(mysqlToSqlLookupTable, MYSQL_TYPE_TIMESTAMP, "DATETIME");
         psDBAddToLookupTable(mysqlToSqlLookupTable, MYSQL_TYPE_DATE,      "DATE");
         psDBAddToLookupTable(mysqlToSqlLookupTable, MYSQL_TYPE_TIME,      "TIME");