#	Working With SQLite Dates

SQLite is invisibly one of the most popular databases in the world, being as it is embedded inside other software. It is free, well designed, and allows an application to work with a database without the pain of actually setting up a database server.

However, SQLite does have a few quirks, which will befuddle many newcomers to SQLIte:

- Database columns do not have a type, but an __affinity__. This means that you can put any type of data in any column, but there is a default interpretation of the data.
- SQLite does not have a Date type (or affinity). Instead, you choose between integers, reals or strings, and convert your data accordingly.

It is the date which can cause a lot of heartache. Hopefully, the following will help.