Date save as zero (0) in the SQLite database

Discussion in 'Questions (Windows Mobile)' started by mozaharul, Apr 1, 2008.

  1. mozaharul

    mozaharul Active Member Licensed User

    In the SQLite insert command the "insert into geo values(calender1.values)" save the date as ticks.

    But if I use " insert into geo values(date(calender1.values))" then it saves zero (0) in the database.


    Please help


    regards
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    Try:
    Code:
    "insert into geo values('" & date(calender1.values) & "')"
     
  3. mozaharul

    mozaharul Active Member Licensed User

    It works.
    Thank you very much sir.
     
Loading...