Adding a new column ALTER TABLE tbl_status ADD COLUMN status_default TEXT; This will cause an error if the column already exists. To check if a column already exists first you can use: PRAGMA table_info(tbl_status); which will return a table listing the columns of the table. However many people use the built in PRAGMA user_version) to store […]
https://www.sqlite.org/lang_datefunc.html Reading DateTime In Select Statements You need to specify you want the value returning in a DateTime format or you can just get the year portion returned! Command1->CommandText = "SELECT datetime(LogDateTime) as LogDateTime, SomeOtherColumnName FROM MyTable"; Faster Searches Based On Date One nice and simple solution is to store dates as an intiger using this […]
See our C# page here.