Wojciech wrote:
> I would ask, if there is any possibility to sort data in sqlite tables by
> date, which is stores in RFC 822 format. I have data in this format, which
> comes from RSS channels - in RSS specification RFC 822 it's required.
>
> Sample date looks like that: Sat, 07 Sep 2002 00:00:0
Hi,
I would ask, if there is any possibility to sort data in sqlite tables by
date, which is stores in RFC 822 format. I have data in this format, which
comes from RSS channels - in RSS specification RFC 822 it's required.
Sample date looks like that: Sat, 07 Sep 2002 00:00:01 GMT
I tried with s
Karthick V - TLS , Chennai wrote:
Hello everyone,
I am trying to retrieve some records from the database using date and time
comparison. The table has three columns, Row Id, Start Time and end Time.
I need to get the row id for a time which falls within the start and end
time.
I am using
Hello everyone,
I am trying to retrieve some records from the database using date and time
comparison. The table has three columns, Row Id, Start Time and end Time.
I need to get the row id for a time which falls within the start and end
time.
I am using this query.
select RowID,
strftime('
Your machine has the timezone recorded and localtime uses that to make
the appropriate correction from UTC (Greenwich or Zulu) time.
This approach makes the time correct if you are operating across time
zones. It is the way your Unixepoch time expects to work. A machine
which gives the corre
Thanks Craig Morrison. Now I got the idea clearly.
On Wed, 2006-11-08 at 00:55 -0500, Craig Morrison wrote:
> Lloyd wrote:
> > select datetime(1162961284,'unixepoch','localtime');
> >
> > 2006-11-08 10:18:04
> >
> > The result is correct.
> >
> > I would like to know how sqlite is performing
Lloyd wrote:
select datetime(1162961284,'unixepoch','localtime');
2006-11-08 10:18:04
The result is correct.
I would like to know how sqlite is performing the localtime correction.
timestamps are in relation to UTC.. When you use the localtime modifier,
you are instructing the code to ad
Hi,
I felt sqlite's date and time functions are very useful and suits my
needs.
But still am not clear about one thing. I gave the following query
select datetime(1162961284,'unixepoch');
2006-11-08 04:48:04
The date is correct but the time is 5 hours lagging. So for local time
correction I ga
tetime differences with simple aritmetic
3. it is the "native" format inside the SQLite date and time functions
4. it is the format returned from the internal now() function
and the disadvantages that
1. conversion to datetime formatted strings needed for human consumption
2. queries
written to and read from the
database.
Representing your datetimes as Julian dates has the advantages that
1. you get the most time resolution for the fewest bytes
2. you can compute datetime differences with simple aritmetic
3. it is the "native" format inside the SQLite date and time f
Kurt Welgehausen wrote:
DRH wrote
The date and time functions ... are fully tested ...
I'm using SQLite version 2.8.8, precompiled binaries, on Linux.
The date/time functions seem to work, but some of the modifiers
don't. Specifically, 'gregorian', 'julian', 'start of week',
'localtime', and 'ut
DRH wrote
>> The date and time functions ... are fully tested ...
I'm using SQLite version 2.8.8, precompiled binaries, on Linux.
The date/time functions seem to work, but some of the modifiers
don't. Specifically, 'gregorian', 'julian', 'start of week',
'localtime', and 'utc' all cause the funct
Got it!! =)
Thank you so much again!!
Roger.
- Original Message -
From: W Allan Edwards
To: [EMAIL PROTECTED]
Sent: Monday, January 05, 2004 12:53 PM
Subject: Re: [sqlite] Date and Time functions are experimental
By my understanding of the code, it is turing into into
e typecast, so I would
like to choose what costs less, in my case.
Thanx!!
Roger.
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: "'SQLite Mailingliste'" <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 11:37 AM
Subject: [
Allan Edwards wrote:
I looked through the source code and those functions "WERE" experimental.
They appear to be a full non experimental in the sqlite source code at this
point. Thus far I have not found any problems with them. You can #define
them out on a compilation if you don't want date rout
15 matches
Mail list logo
