Jake Skinner wrote:
I seem to be having some problems with time. I am storing "17:30" into
SQLite. When I do a 'select time(time_col) from table' I am receiving
"05:29:59". Being one second out, I can kind of live with but, not
returning the correct 24 hour format I can't. I'm sure I'm doing
something wrong, however I am completely stumped as to what!
Any ideas?
First, time functions are still considered experimental. So do
not get too attached to them because they will probably change.
Second, the bug you are seeing was fixed in a later release
(available on the CVS server). An even later update
completely rewrote the time functions. The code that is
currently in the latest CVS should be what you use.
If you get the latest source code out of CVS and compile it,
things should work a lot better for you.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
