RE: [sqlite] Date Problems

2008-01-06 Thread Brad Stiles
> 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

RE: [sqlite] Date Problems

2008-01-03 Thread Wilson, Ron
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

RE: [sqlite] Date Problems

2008-01-03 Thread Moodie Keith
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

Re: [sqlite] Date Problems

2008-01-03 Thread John Stanton
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

RE: [sqlite] Date Problems

2008-01-03 Thread Griggs, Donald
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

RE: [sqlite] Date Problems

2008-01-03 Thread Craig.Street
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

Re: [sqlite] Date Problems

2008-01-02 Thread John Stanton
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

Re: [sqlite] Date Problems

2008-01-02 Thread Rich Shepard
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

Re: [sqlite] Date Problems

2008-01-02 Thread drh
<[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

Re: [sqlite] Date Problems

2008-01-02 Thread Kees Nuyt
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

[sqlite] Date Problems

2008-01-02 Thread Craig.Street
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