This sounds like a "DB Browser" issue, whatever a "DB Browser" is. You should direct questions about how to enter SQL commands into "DB Browser" to the "DB Browser" support channel.
This is especially true since it appears that you have solved the problem satisfactorily when using the SQLite3 command line shell. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >[email protected]] On Behalf Of Miel Loinaz >Sent: Saturday, 23 December, 2017 21:34 >To: [email protected] >Subject: [sqlite] Modify the sqlite database with DB Browser to >update a new field > >Hello, >I want to modify a sqlite database of a weather station software >(wewx.sdb). Date >and time are in the form of echo or linux time (field date1). I have >added >a new field (date2) where I want to display human readable date and >time. > >In Linux console I get it running: > >UPDATE table1 SET date2 = datetime (date1, 'unixepoch', 'localtime'); > >But I do not know how to modify the sqlite database with DB Browser, >I'm a >newbie. Where should I enter this code? > >Thanks and Merry Christmas! >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
