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
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
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,
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
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
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
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
>
Sent: Monday, January 05, 2004 7:40 PM
Subject: Re: [sqlite] Date and Time functions are experimental
Here are some clarifications about date and time functions.
SQLite stores everything in the database as a string. You may choose
to represent your datetimes in the database as Julian
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
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
11 matches
Mail list logo