jeudi 5 novembre 2015

How to store a date in SQLite?

How do I store on a table a value date using the format 'yyyy -mm- dd' ? because SQLITE does not have a specific type to store this kind of value ?

Example of use:

SELECT * FROM MySimpleTable
WHERE DeliveryDate between '1/11/2015' AND '6/11/2015'

Aucun commentaire:

Enregistrer un commentaire