On 05 Feb 2019, at 13:08, Scott <scottvall...@yahoo.com> wrote: > I have a Comment table with the fields: CommentID, Summary, Comment, Pages, > TimeStamp, Hyperlink. The TimeStamp field is setup as a Time(8), time with 8 > characters only. Not every comment in this table requires a timestamp, so it > should remain null. However, it has started adding "Thu Jan 01 00:00:00 EST > 1970" and it will not let me clear it. This is being populated with the > following Java code, in the past, it would just remain null. I included a > Regular Expression to check the GUI field data when it is used. But, I can't > even manually clear it now and I haven't changed the setup of the database, > the table or TimeStamp field. > Any thoughts or suggestions?
1) Please show your whole table definition for the comment table. 2) Time(8) has no meaning to SQLite, your timestamp field will probably default to TEXT. See: https://www.sqlite.org/datatype3.html -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
