IOS, SQLite and working with datetime?

Question

iOS

I am new to iOS programming and working with SQLite database. Prior to that, he worked with MS SQL.
SQLite does not have the same data type as DateTime. How to work with dates? In what format to save?
There is a table with 2 fields: name text, created text.
In the created field, date and time (in the format yyyy-MM-dd HH:mm:ss). How to make a selection in a range of dates? For example, I need to get all entries that were made on January 5, 2012?

Answer 1

Look here: http://www.sqlite.org/lang_datefunc.html

Answer 2

Wouldn't it be easier to use int or real for such purposes?
www.sqlite.org/datatype3.html#datetime