You may have the difficulty of a VFP date is not a SQL date. getdate() is the system datetime.
-- convert a date to String SELECT convert(varchar(25), getdate(), 120) -- date part only SELECT CONVERT(date, getdate()) On Wed, Apr 26, 2017 at 3:33 PM, Richard Kaye <rk...@invaluable.com> wrote: > Whil Hentzen wrote an eBook on working with SQLLite. > > http://www.hentzenwerke.com/catalog/sqlite2gb.htm > > > -- > > rk > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of José > Olavo Cerávolo > Sent: Wednesday, April 26, 2017 4:24 PM > To: profoxt...@leafe.com > Subject: Reading from SQLite > > Hi Guys, > I sent a message but it guess it was misplaced.I am trying to read a > SQLite database, but I have problems with the data.I can connect to it, > read the tables, but the values are messed up.I can't get the Dates, it > comes out as .NULL or with weird numbers.I've looked at the documentation, > but nothing is working.I am using the SQLite ODBC for SQLite version 3. > Thanks in advance, > Jose. > José Olavo Cerávolohttp://www.ceravoloconsulting.com/ > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjnqutisyb+-ta__yjqjtjf9cwvx+fn8tg46a3u+ri...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.