CODEWITHSUNDEEP
sqlitedateformat
SAVERIO FLORIO
SAVERIO FLORIO

Reputation: 3

What date format use in sqlite

I have a sqlite table within a column type DATE. Why doesn't this query work? I save my date in this format: dd-MM-YYYY

SELECT * FROM scadenze where data < strftime ('%d-%m-%Y', '31-03-2017') ;

Upvotes: 0

Views: 626

Answers (1)

CL.
CL.

Reputation: 180020

This is not one of the supported date formats. Better use yyyy-mm-dd.

Upvotes: 1

Related Questions