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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users