"info" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> If I use the expression datetime('2000-01-01','1.5 months'), SQLite returns
> 2000-02-16 00:00:00. This means that it added one month plus half a month.
> Makes sense.
>
> If I use the expression datetime('2000-01-01','1.5 days'), I get 2000-01-02
> 12:00:00. Again this makes sense: 1.5 days is equal to 1 day plus 12 hours.
>
> But with the expression datetime('2000-01-01','1.5 years') the result is
> 2001-01-01 00:00:00. Which means, SQLite added only 1 year and not an extra
> 6 months.
>
> Can anyone explain why using decimals works for months and days and not for
> years?
>
Because nobody has ever written the code to do that. :-)
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
