SQLite: get day

Question

How can I return the day of a DateTime in SQLite?

I have my field Date stored as a DateTime. Now I would like get the day from each row (just the day, not the full date).

I tried using the following, but it doesn't work. It doesn't give an error, but it just returns nothing

SELECT strftime('%d', Date) FROM sessiondate

Answer 1

SELECT strftime('%d', `Date`) FROM sessiondate

might work