Java MySQL Timestamp Saving -


i store lot of application timestamps in mysql db , 1 weird thing observing when store day end time 2014-10-29 23:59:59.999 , when check same in db table rounds timestamp next second , shows 2014-10-30 00:00:00.000 there wrong doing here or issue mysql.i storing timestamps in utc.

-regards, willsteel

up until mysql 5.6.4 fractional seconds discarded. see http://dev.mysql.com/doc/refman/5.6/en/datetime.html

a datetime or timestamp value can include trailing fractional seconds part in microseconds (6 digits) precision. in particular, of mysql 5.6.4, fractional part in value inserted datetime or timestamp column stored rather discarded.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -