What has been done with date and time functions is great.
I would like to suggest a further extension to these functions, at the
moment (I'm really only talking about the time functions however it
could also apply to the date functions as well) it is possible to select
either the hour or
Jake Skinner wrote:
Could anyone suggest other ways of achieving summing of times ie
sum(end_time - start_time). At the moment I have a rather unwieldy sql
query (see below).
sum(
(strftime("%H",end_time)*60+strftime("%M",end_time)) -
D. Richard Hipp wrote:
Jake Skinner wrote:
Could anyone suggest other ways of achieving summing of times ie
sum(end_time - start_time). At the moment I have a rather unwieldy sql
query (see below).
sum(
(strftime("%H",end_time)*60+strftime("%M",end_time)) -
Andrzej Kukula wrote:
Could you please point me to some material describing Julian Date that
SQLite uses? Googling through the Net reveals that there are many
definitions that differ in respect to start date, ranging from January 1st
4714 B.C. to January 1st 4712 B.C.
References and explanations
According to the excellent "Calendrical Calculations" by Reingold &
Dershowitz,
Julian Day 0 = Noon, Monday 1st January 4713 BC (Julian Calendar)
Noon, Monday 24th November -4713 (Proleptic Gregorian
Calendar)
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL
Drew, Stephen wrote:
According to the excellent "Calendrical Calculations" by Reingold &
Dershowitz,
Julian Day 0 = Noon, Monday 1st January 4713 BC (Julian Calendar)
Noon, Monday 24th November -4713 (Proleptic Gregorian
Calendar)
SQLite uses Nov 24, 4714 B.C. (Gregorian) which
D. Richard Hipp wrote:
D. Richard Hipp wrote:
Jake Skinner wrote:
Could anyone suggest other ways of achieving summing of times ie
sum(end_time - start_time). At the moment I have a rather unwieldy
sql query (see below).
sum(
(strftime("%H",end_time)*60+strftime("%M",end_time)) -
How can I check whether my sparc has any alignment restriction
that is more severe than what was expected ?
thanks,
Sujit
"D. Richard Hipp" <[EMAIL PROTECTED]>
02/23/2004 06:53 PM
To
[EMAIL PROTECTED]
cc
Paul Riethmuller <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject
Re: [sqlite] Re: has
[EMAIL PROTECTED] wrote:
How can I check whether my sparc has any alignment restriction
that is more severe than what was expected ?
For starters, you could compile it such that you get the
segmentation fault. Run it in a debugger. Then send me
the line number where the fault occurred. Be sure
> I've searched around quite a bit for an answer on this but I haven't
> found anything yet. As far as I understand the following is a valid
> SQL-92 query:
Have you tried it on some other SQL-92 compliant DB and had it work? I've
never seen "all" used in quite that way before. Admittedly, I've
> Have you tried it on some other SQL-92 compliant DB and had it work? I've
> never seen "all" used in quite that way before. Admittedly, I've only used
> SQL Server, Oracle, MSDE, Access and now SQLite, so maybe that's just me.
I'm actually taking these examples from my database textbook
I've been playing around with using SQLite for a data store in a
newsreader app for a few days now, and I keep getting the database
stuck in a locked state. The only thing that seems to fix it is
deleting the file and starting over. I tried recompiling with
-DTHREADSAFE=1, but it didn't seem
I've make some experiments around accessing the SQLite database fom concurent
processes at the same time
and I find it work good when I'm using transactions every time I touch the database.
When I don't, it corrupt the database file sometimes.
> -Original Message-
> From: [EMAIL
13 matches
Mail list logo
