[EMAIL PROTECTED] wrote:
> I think it was the date format in the SQLite table that wasn't right.
> I had this as dd-mm-yyyy
>
> Doing SELECT date('2006-02-16','+1 month')
> gives me indeed correctly 16 Feb 2006
>
> So does the format have to be yyyy-mm-dd ?
>
Yes. That format is called ISO-8601. Everybody in the world
is moving to it (some faster than others). You would do well
to get on board.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
