Re: [sqlite] subtracting days from two dates

mithin wrote: Hi, I want to find if the difference between the days of two dates is less than or greater than some number. The year is not in the picture and it can be anything. I gave the following query but it is not working. SELECT * FROM date_details WHERE (date(date_details.value,%j) - dat

Re: [sqlite] subtracting days from two dates

On 6/27/06, mithin <[EMAIL PROTECTED]> wrote: Hi, I want to find if the difference between the days of two dates is less than or greater than some number. The year is not in the picture and it can be anything. I gave the following query but it is not working. SELECT * FROM date_details WHERE (

[sqlite] subtracting days from two dates

Hi, I want to find if the difference between the days of two dates is less than or greater than some number. The year is not in the picture and it can be anything. I gave the following query but it is not working. SELECT * FROM date_details WHERE (date(date_details.value,%j) - date('now',%j) < 3