Re: [sqlite] Are SQLite offer dates with timezone support?

2004-10-16 Thread D. Richard Hipp
Tito Ciuro wrote: Hello, The only reference I see about timezone support in SQLite is in this example: Compute the date and time given a unix timestamp 1092941466, and compensate for your local timezone. SELECT datetime(1092941466, 'unixepoch', 'localtime'); I found this here:

[sqlite] Are SQLite offer dates with timezone support?

2004-10-16 Thread Tito Ciuro
Hello, The only reference I see about timezone support in SQLite is in this example: Compute the date and time given a unix timestamp 1092941466, and compensate for your local timezone. SELECT datetime(1092941466, 'unixepoch', 'localtime'); I found this here:

Re: [sqlite] SQLITE_BUSY returned without busy handler called

2004-10-16 Thread D. Richard Hipp
Kevin Schmeichel wrote: By examining the code, it can be seen that there are many places where SQLITE_BUSY is returned (from an API function) without the busy handler being called. Anyone know if there is any reason for this? I would have thought that the busy handler would be called *every*

Re: [sqlite] Support for ODBC?

2004-10-16 Thread Yves Chaufour
Le vendredi 15 Octobre 2004 09:23, Eric Bohlman a écrit : > R S wrote: > > Can an application access data from SQLite via ODBC? Didn't see > > documentation on the same. > > If you have an ODBC driver for SQLite, yes. The "SQLite Wrappers" page > of the wiki mentions "ODBC driver for SQLite.

Re: [sqlite] GUI ?

2004-10-16 Thread Demitri Muna
Take a look at the excellent QuickLite Cocoa wrapper. http://www.webbotech.com/ It has a few sample applications, including one called "SQLIteManagerX" which may be sufficient for your needs. Demitri --- On Oct 15, 2004, at 8:53 PM, Richard wrote: wondering if there are any Mac OS X GUI