Changeset 17904 for trunk/psLib

Timestamp:

Jun 4, 2008, 2:25:49 PM (18 years ago)

Author:

jhoblitt

Message:

add support for parseing "0000-00-00..." datetime/timestamp 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.160 2008-05-31 02:16:52 jhoblitt Exp $
+ * $Id: psDB.c,v 1.161 2008-06-05 00:25:49 jhoblitt Exp $
  */
 
@@ -1198 +1198 @@
                         return NULL;
                     }
+                } else if (psStrcasestr(data, "0000-00-00 00:00:00") == 0) {
+                    // look for 0000-00-00 00:00:00, which can't be parsed by
+                    // psTimeStrptime as the month/day are bogus
+                    if (!psMetadataAddTime(md, PS_LIST_TAIL, field[i].name, 0, "", NULL)) {
+                        psError(PS_ERR_UNKNOWN, false, "Failed to add item %s", field[i].name);
+                        psFree(data);
+                        psFree(md);
+                        mysql_free_result(result);
+                        psFree(resultSet);
+                        return NULL;
+                    }
+                    psFree(time);
+
                 } else {
                     psTime *time = psTimeStrptime((char *)data, "%EY-%m-%d%t%T");