Re: [sqlite] Date Difference - How do I subtract two dates

[drh]

Dr Gerard Hammond <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> How do I subtract two dates and get the answer in minutes?


    SELECT (julianday(date1) - julianday(date2))*1440;

--
D. Richard Hipp   <[EMAIL PROTECTED]>