Re: [sqlite] Conversion string -> date

2008-03-28 Thread Igor Tandetnik
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Fri, Mar 28, 2008 at 02:39:23PM -0400, Igor Tandetnik wrote: > >> date() function produces a string. You are trying to subtract a >> number from a string, at which point SQLite converts the string to >> number ('2008-03-28' becomes 2008) and

Re: [sqlite] Conversion string -> date

2008-03-28 Thread Zbigniew Baniewski
On Fri, Mar 28, 2008 at 02:39:23PM -0400, Igor Tandetnik wrote: > date() function produces a string. You are trying to subtract a number > from a string, at which point SQLite converts the string to number > ('2008-03-28' becomes 2008) and performs the subtraction (2008 - 14 == > 1994). I