[sqlite] Best way to store only date

[Cecil Westerhof]

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