Retrieving data from sqlite on the basis of date

Retrieving data from sqlite on the basis of date

I am retrieving data from Sqlite database using the following query in c#
SELECT * FROM tableName
It works fine. But I want to retrieve data on the basis of date like:
SELECT * FROM tableName WHERE date=09-09-2013
But it do not works for me because Sqlite date representation is not in
this date format. What i want to ask is that is there any method by which
Sqlite data can be retrieved on the basis of user date and time like
mentioned in above query and how can I represent date and time of Sqlite
database in user readable format.