Index: src/date.c ================================================================== --- src/date.c +++ src/date.c @@ -600,11 +600,11 @@ p->Y = sLocal.tm_year + 1900 - iYearDiff; p->M = sLocal.tm_mon + 1; p->D = sLocal.tm_mday; p->h = sLocal.tm_hour; p->m = sLocal.tm_min; - p->s = sLocal.tm_sec + (p->iJD%1000)*0.001; + p->s = sLocal.tm_sec; p->validYMD = 1; p->validHMS = 1; p->validJD = 0; p->rawS = 0; p->validTZ = 0; Index: test/date.test ================================================================== --- test/date.test +++ test/date.test @@ -537,11 +537,8 @@ datetest 17.4 {datetime(2457828,'start of month')} {2017-03-01 00:00:00} datetest 17.5 {datetime(2457828,'start of year')} {2017-01-01 00:00:00} datetest 17.6 {datetime(37,'start of year')} NULL datetest 17.7 {datetime(38,'start of year')} {-4712-01-01 00:00:00} -# 2022-03-04 https://sqlite.org/forum/forumpost/2ffbaa2c3fd7fb82 -# The 'localtime' modifier should preserve fractional seconds. -# -datetest 18.1 {strftime('%f',1.234,'unixepoch','localtime')} {01.234} + finish_test