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 suggestions / workarounds greatfully received!
Confirmed.
Better:
select date('2006-03-31', 'start of month','-1 month');
>Many thanks
HTH
>Craig
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
