sqlite date

Discussion in 'iPhone/iPad Programming' started by chhoda, Oct 27, 2009.

  1. macrumors 6502

    Joined:
    Oct 25, 2008
    #1
    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 ?


    --CH
     
  2. macrumors 68030

    PhoneyDeveloper

    Joined:
    Sep 2, 2008
    #2
    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