According to <http://en.wikipedia.org/wiki/Leap_second>, the following should be perfectly valid:
$ fossil new --date-override 2012-06-30T23:59:60 foo.fossil unrecognized date format (2012-06-30T23:59:60): use "YYYY-MM-DD HH:MM:SS.SSS" Suggested patch to fossil (and SQLite trunk, with adapted test-case): Regards, Jan Nijtmans Index: src/sqlite3.c ================================================================== --- src/sqlite3.c +++ src/sqlite3.c @@ -14769,11 +14769,11 @@ return 1; } zDate += 5; if( *zDate==':' ){ zDate++; - if( getDigits(zDate, 2, 0, 59, 0, &s)!=1 ){ + if( getDigits(zDate, 2, 0, 60, 0, &s)!=1 ){ return 1; } zDate += 2; if( *zDate=='.' && sqlite3Isdigit(zDate[1]) ){ double rScale = 1.0; Index: src/date.c ================================================================== --- src/date.c +++ src/date.c @@ -175,11 +175,11 @@ return 1; } zDate += 5; if( *zDate==':' ){ zDate++; - if( getDigits(zDate, 2, 0, 59, 0, &s)!=1 ){ + if( getDigits(zDate, 2, 0, 60, 0, &s)!=1 ){ return 1; } zDate += 2; if( *zDate=='.' && sqlite3Isdigit(zDate[1]) ){ double rScale = 1.0; Index: test/date.test ================================================================== --- test/date.test +++ test/date.test @@ -64,13 +64,14 @@ datetest 1.23 julianday(12345.6) 12345.6 datetest 1.23b julianday('12345.6') 12345.6 datetest 1.24 {julianday('2001-01-01 12:00:00 bogus')} NULL datetest 1.25 {julianday('2001-01-01 bogus')} NULL datetest 1.26 {julianday('2001-01-01 12:60:00')} NULL -datetest 1.27 {julianday('2001-01-01 12:59:60')} NULL +datetest 1.27 {julianday('2001-01-01 12:59:61')} NULL datetest 1.28 {julianday('2001-00-01')} NULL datetest 1.29 {julianday('2001-01-00')} NULL +datetest 1.30 {julianday('2001-01-01 12:59:60')} 2451911.04166667 datetest 2.1 datetime(0,'unixepoch') {1970-01-01 00:00:00} datetest 2.1b datetime(0,'unixepoc') NULL datetest 2.1c datetime(0,'unixepochx') NULL datetest 2.1d datetime('2003-10-22','unixepoch') NULL _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users