Re: Reading from SQLite

2017-04-27 Thread Ted Roche
f tables:23 > number of indexes: 14 > number of triggers: 0 > number of views: 0 > schema size: 8265 > Subject: Re: Reading from SQLite > Message-ID: > > Content-Type: text/plain; charset="utf-8" > > On Thu, Apr 27, 2017 at 12:17 PM,

Re: Reading from SQLite

2017-04-27 Thread Stephen Russell
Try this page as well: http://www.sqlite.org/lang_datefunc.html Time Strings A time string can be in any of the following formats: 1. *-MM-DD* 2. *-MM-DD HH:MM* 3. *-MM-DD HH:MM:SS* 4. *-MM-DD HH:MM:SS.SSS* 5. *-MM-DD**T**HH:MM* 6. *-MM-DD**T**HH:MM:SS*

Re: Reading from SQLite

2017-04-27 Thread José Olavo Cerávolo
8265 Subject: Re: Reading from SQLite Message-ID:     Content-Type: text/plain; charset="utf-8" On Thu, Apr 27, 2017 at 12:17 PM, Jos? Olavo Cer?volo wrote: > Hi Ted, > The dates on the existing table are not .NULL..When I get the date using what > you suggested, datet

Re: Reading from SQLite

2017-04-27 Thread Ted Roche
On Thu, Apr 27, 2017 at 12:17 PM, José Olavo Cerávolo wrote: > Hi Ted, > The dates on the existing table are not .NULL..When I get the date using what > you suggested, datetime(yourfield,'unixepoch','localtime'), I get this date > on an MEMO field 1984-10-05 23:00:00. This date is not the actual

Re: Reading from SQLite

2017-04-27 Thread José Olavo Cerávolo
g that could actually help me. Thanks, Jose. Message: 7 Date: Wed, 26 Apr 2017 16:58:56 -0400 From: Ted Roche To: profoxt...@leafe.com Subject: Re: Reading from SQLite Message-ID:     Content-Type: text/plain; charset="utf-8" .NULL. is a perfectly valid date. If you're getting n

Re: Reading from SQLite

2017-04-27 Thread Ted Roche
On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo wrote: > 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

Re: Reading from SQLite

2017-04-26 Thread Ted Roche
.NULL. is a perfectly valid date. If you're getting numbers, you're likely getting dates stored as days since some arbitrary date. Try: select datetime(yourfield,'unixepoch','localtime') from yourtable; On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo wrote: > Hi Guys, > I sent a message bu

Re: Reading from SQLite

2017-04-26 Thread Stephen Russell
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 wrote: > Whil Hentzen wrote

RE: Reading from SQLite

2017-04-26 Thread Richard Kaye
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 Subje