When creating a table, according to the syntax, a column can be specified with DEFAULT column constraint and "The DEFAULT constraint specifies a default value to use when doing an INSERT ...If the value is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the current UTC date and/or time is inserted into the columns."
Here's what I have. Create table TemperatureData ( Tempt real, TimeStamp default CURRENT_TIMESTAMP); Insert into TempertaureData values( 40.2, NULL); The code above creates a table storing a temperature value with the current timestamp. I would give TimeStamp a type, but I am not sure what type is appropriate (text or blob). The code as written does NOT insert the current time stamp to the last field, but leaving it empty (as NULL indicates). I would get a syntax error if I literally leave the second field blank. Does anyone know how it works? Also, I would like to know what type I should use for the comparison operator to properly compare times on the automatically generated time stamp.
