To store date and time at the moment I use: datetime INT NOT NULL DEFAULT (strftime('%s'))
For storing a date I probably could use strftime('%J'). But I would like to store it as an INT. But I see no way to cast a float to an int. Is that not possible? Or is it better just keeping to use: date TEXT NOT NULL DEFAULT CURRENT_DATE -- Cecil Westerhof