b99aaab26e9c9f9a5f5b9e0c9be024e8a9f10b38 galt Wed Feb 13 12:57:49 2013 -0800 time should be time_t or long but not int, so that the 2030 overflow problem is avoided on 64-bit machines diff --git src/hg/lib/jksql.c src/hg/lib/jksql.c index 4ad092f..3e1bb3f 100644 --- src/hg/lib/jksql.c +++ src/hg/lib/jksql.c @@ -2159,31 +2159,31 @@ break; case '*': *s++ = '%'; break; case '?': *s++ = '_'; break; default: *s++ = c; break; } } return retVal; } -int sqlDateToUnixTime(char *sqlDate) +long sqlDateToUnixTime(char *sqlDate) /* Convert a SQL date such as "2003-12-09 11:18:43" to clock time * (seconds since midnight 1/1/1970 in UNIX). */ { struct tm *tm = NULL; long clockTime = 0; if (sqlDate == NULL) errAbort("Null string passed to sqlDateToClockTime()"); AllocVar(tm); if (sscanf(sqlDate, "%4d-%2d-%2d %2d:%2d:%2d", &(tm->tm_year), &(tm->tm_mon), &(tm->tm_mday), &(tm->tm_hour), &(tm->tm_min), &(tm->tm_sec)) != 6) errAbort("Couldn't parse sql date \"%s\"", sqlDate); tm->tm_year -= 1900; tm->tm_mon -= 1;