Difference between two dates.

[Huskar]

I want to fetch all price row which have difference of start date and end date greater than 10 days. How can I do that?

[Former Member]

Hi Krishn,

Please try below query:

 SELECT *
 FROM {PriceRow as p}
 WHERE {p.endTime} > {p.startTime} - INTERVAL 10 DAY

The PriceRow extends PDTRow which has startTime/endTime fields instead of startDate/endDate.

Hope this helps.
Best Regards,

[VinayKumarS]

 If the database is oracle..
 
 select * from {PriceRow} where to_date( {starttime},'dd-MM-yyyy')>=to_date(sysdate-10,'dd-MM-yyyy')

[Former Member]

I think that Krishn asked about start-end date difference and your query works on difference between start date and current date (which might be different than end date).