Hi all:
I would like to know if there are a way to obtain a result without decimals
(the integer part) in this query:
SELECT round(julianday('now')-Dat) FROM SomeTable WHERE ...;
Obviously Dat contain a Julian Date (nnn.nnn) and I want the difference in
days from today.
None the above,
See the floor function (largest integer value not greater than argument)
in
http://sqlite.org/contrib/download/extension-functions.tgz?get=17
On 5/6/07, A.J.Millan [EMAIL PROTECTED] wrote:
Hi all:
I would like to know if there are a way to obtain a result without
decimals
(the integer part)
A.J.Millan [EMAIL PROTECTED] wrote:
I would like to know if there are a way to obtain a result without
decimals (the integer part) in this query:
CAST(expr AS INTEGER)
Igor Tandetnik
-
To unsubscribe, send email to
Will the anonymous user who contributed the remark to
ticket #2339 on 2007-May-06 18:03:48 that contains a
6-line patch for fixing the ticket, please identify
yourself to me. Tnx.
--
D. Richard Hipp [EMAIL PROTECTED]
-
Dan Kennedy wrote:
On Fri, 2007-05-04 at 18:22 -0400, Vitali Lovich wrote:
Multiple tables contain a primary key KEY. If Table1 contains a
matching KEY, then I want that row from Table1. Only if it isn't in
Table1, then look in Table2 if it is there. If not in Table2 go on to
Table3, etc
Is there a sqlite introduction for programmers wanting to use the sqlite C
API? The info on the web site is pretty sparse. There seems to be plenty of
info regarding the use of sqlite3 all over the web. But not much on getting
set up to write programs that use sqlite.
I have some specific
You ask too many questions in one go. I will be surprised if anyone
is willing to provide that much assistance all at once.
It appears that you need some more fundamental knowledge about
programming on GNU/Linux and maybe even about programming in C.
Some of your questions are contradictory and
How about this?
update tablename set newcolname=(case rowid when 1 then 1 else 2 end);
best regards,
Radzi
- Original Message -
From: Tomash Brechko [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Saturday, May 05, 2007 8:09 PM
Subject: Re: [sqlite] how to add a new column
Hello C.Peachment,
Yeah, I wasn't going to answer. Clearly this person hasn't even read
the website which is where all the documentation resides.
C
Sunday, May 6, 2007, 10:38:59 PM, you wrote:
CP You ask too many questions in one go. I will be surprised if anyone
CP is willing to provide that
