Lloyd thomas wrote:
> Will there be a simple way to update SQLite in PHP on a windows platform so
> that I can use the new date/time functions?
>
You'll have to ask the PHP people about that.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
Thank you DRH,
I did manage to sort out my problem with the help
from another member. The functions you are adding I'm sure will be
appreciated. Will there be a simple way to update SQLite in PHP on a windows
platform so that I can use the new date/time functions?
Lloyd
Lloyd thomas wrote:
I have a table that shows a list of connections showing the time the
connection was finished and the duration.
I wish to show concurrent connections during a particular minute.
for instance the following would show that there was two connections during
2003-12-04 09:27:00
Kurt,
I managed to resolve my problem with the following. Thanks for your help.
code
SELECT round((julianday(duration)-julianday('00:00:00')) * 86400) as
duration_sec
FROM call_data
WHERE julianday(call_time) <= julianday('2003-12-03 18:42')
AND
I have a table that shows a list of connections showing the time the
connection was finished and the duration.
I wish to show concurrent connections during a particular minute.
for instance the following would show that there was two connections during
2003-12-04 09:27:00
Bronislav wrote:
I usualy download every new version of SQLite, ...there is no change in description
since 2003/10. Should that
mean that there was no change?
There isn't a change in the public API at every update. If there is a
change in the version number, then there are obviously changes in
>> SELECT TIME_TO_SEC(duration)as duration
>> FROM call_data where call_time <= '2003-12-04 16:41'
>> AND DATE_SUB('2003-12-04 16:41', INTERVAL duration HOUR_SECOND) <= call_time
Try
SELECT round((julianday(duration)-julianday('00:00:00')) * 86400) as duration
FROM call_data where call_time
I know there are now some time functions in sqlite, but I did not quite understand the
functions available in it. I apologise for the MySQL references below, but I wish to
achieve the query below with SQLite, assuming some of you are fimiliar with MySQL. Can
you help?
Hi,
I usualy download every new version of SQLite, I'm writing my own Delphi
interface but there is no change in description since 2003/10. Should that
mean that there was no change?
Brona
-
To unsubscribe, e-mail: [EMAIL
9 matches
Mail list logo