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 (julianday('2
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
--
>> it relies on having the seconds as well.
I don't understand the question. As far as I know,
nothing in SQLite requires the seconds.
sqlite> select julianday('2003-12-04 16:41');
julianday('2003-12-04 16:41')
-
2452978.19513889
If you're getting an err
- Original Message -
From: "Lloyd thomas" <[EMAIL PROTECTED]>
To: "Kurt Welgehausen" <[EMAIL PROTECTED]>
Sent: Saturday, February 28, 2004 8:34 PM
Subject: Re: [sqlite] time calculations
> Thanks Kurt,
> Nearly there, but not quite. In the datetime string I
have,
> it re
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 th
>> 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?
code--
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 PROTE
11 matches
Mail list logo
