> Can somebody give any explain to this please.
> sqlite> select date("2006-03-31");
> 2006-03-31
> --> correct
>
> sqlite> select date("2006-03-31", "-1 month");
> 2006-03-03
> --> not correct
>
>
> Can anyone confirm? Any suggestions / workarounds greatfully
> received!
I've seen other
1.7546
-Original Message-
From: Moodie Keith [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 9:51 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Date Problems
I think the logic might have been to subtract the number of days in the
previous month from the current dat
ope this helps :)
PS Unfortunately dates are messy, but only way to fix them is to change
the spin of the Earth!
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 January 2008 12:17 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Date Problems
L
Nuyt [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 9:25 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Date Problems
Hi Craig,
On Thu, 3 Jan 2008 08:49:42 +0900, <[EMAIL PROTECTED]> wrote:
Hi
Can somebody give any explain to this please.
sqlite> select date(&q
regarding:
>>2006/03/31 minus 1 month : I could accept 28 Feb or 1 Mar as a
reasonable answer and I can make that point to my users.
>>03 March is not reasonable, I can't think of any logic that would give
me that answer and I'm not able to make any case.
I believe the logic used is to
of any logic that would give
me that answer and I'm not able to make any case.
Thanks
Craig
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 9:25 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Date Problems
Hi Craig,
On Thu, 3 Jan
Rich Shepard wrote:
On Thu, 3 Jan 2008, [EMAIL PROTECTED] wrote:
The bottom line is that "one month ago" or "one month from now" is a
fuzzy
concept since months vary in length.
This is a very interesting thread since so many business applications are
highly dependent on dates, yet most
On Thu, 3 Jan 2008, [EMAIL PROTECTED] wrote:
The bottom line is that "one month ago" or "one month from now" is a fuzzy
concept since months vary in length.
This is a very interesting thread since so many business applications are
highly dependent on dates, yet most SQL implementations have
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Can somebody give any explain to this please.
>
> sqlite> select date("2006-03-31");
> 2006-03-31
> --> correct
>
> sqlite> select date("2006-03-31", "-1 month");
> 2006-03-03
> --> not correct
>
"2006-03-31", "-1 month" is "2006-02-31". Except
Hi Craig,
On Thu, 3 Jan 2008 08:49:42 +0900, <[EMAIL PROTECTED]> wrote:
>Hi
>
>Can somebody give any explain to this please.
>
>sqlite> select date("2006-03-31");
>2006-03-31
>--> correct
>
>sqlite> select date("2006-03-31", "-1 month");
>2006-03-03
>--> not correct
>
>
>Can anyone confirm? Any
Hi
Can somebody give any explain to this please.
sqlite> select date("2006-03-31");
2006-03-31
--> correct
sqlite> select date("2006-03-31", "-1 month");
2006-03-03
--> not correct
Can anyone confirm? Any suggestions / workarounds greatfully received!
Many thanks
Craig
Visit our website at
11 matches
Mail list logo