Re: [sqlite] Calculate years and months difference with Julian Date?

[Martin Jenkins]

[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  ?

Only if you want it to work... ;)

Martin

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------