D 2013-01-01T19:32:26.486
J comment I\shave\sdatabase\swith\stable\slike\sthis\r\nCREATE\sTABLE\sTimes\s(Time\sTIMESTAMP\sNOT\sNULL)\r\nIn\sconnection\sstring\sI\shave\sthe\soption\sdatetimeformat=Ticks\r\nWhen\sreading\sfield\sTimes\swith\sSQLiteDataReader\sand\strying\sto\sconvert\sit\sin\sinto\sDateTime\stype,\sexception\s"Invalid\stypecast"\sis\sthrown\sbecause\sreturned\svalue\shas\s"long"\stype.\sIn\sversion\s1.0.74\sand\searlier\sthe\stype\swas\scorrect\s-\sDateTime.\r\nIf\sI'll\schange\sdeclaration\sof\sfield\sin\sdatabase\sto\sDATETIME,\sthen\sall\sgo\sOK.\r\n\r\nExample\scode\shttp://pastebin.com/aQjUe1tV\r\nWhen\slinked\sto\s1.0.74\sit\sshows\sthe\scorrect\sdate,\sbut\swhen\slinked\sto\s1.0.76+,\sprogram\scloses\swith\sexception\n\n<hr\s/><i>mistachkin\sadded\son\s2011-11-29\s22:33:31\sUTC:</i><br\s/>\nFor\snow,\sthe\sbest\sworkaround\sis\sto\suse\sthe\sDATETIME\scolumn\stype\sinstead\sof\sTIMESTAMP?\n\n<hr\s/><i>mistachkin\sadded\son\s2011-11-30\s00:36:19\sUTC:</i><br\s/>\nFixed\sby\scheck-in\s[e96f0d17a5]\son\strunk.
J login mistachkin
J mimetype text/x-fossil-plain
J status Closed
K bb4b04d4578f017ea01ef094a2177687566f7bba
U mistachkin
Z 25b093ea6fa04b44505d2cff5d50a8fe
