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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice