Proper way to index a timestamp in descending order using sqlite?

[brielov]

Hi, I have this transactions table and I'd like to create an index on userId, projectId (which can be null) and timestamp in DESC order. The query will be mostly the same, always. SELECT * FROM transaction WHERE userId = ? AND projectId = ? ORDER BY timestamp DESC. I'm asking cause I know sqlite doesn't have a specific data type for dates / datetimes.