sqlite date

Discussion in 'iOS Programming' started by chhoda, Oct 27, 2009.

  1. macrumors 6502

    Oct 25, 2008
    I am given with a db schema which contains datetime field in table.

    I dont see sqlite function to access.

    is it to be accessed through sqlite3_column_text ?

  2. macrumors 68030


    Sep 2, 2008
    To sqlite everything is text.

    You could use unix time and save seconds as a double.

    You could see what sqlite.org has to say.

Share This Page