-4

I need a sql query which will find the difference between two dates . I have already tried the between clause query but It include the Starting date . But I need a query that exclude the start date . and so please provide me a different one.

MUTHURAJ
  • 261
  • 2
  • 8

1 Answers1

1

You can use the DATEDIFF method

E.g:

SELECT DATEDIFF(SELECT DATE_ADD(start_date,INTERVAL 1 DAY),end_date);

If you want to exclude the start_date, or change the interval as per your requirements

krishnang
  • 698
  • 1
  • 7
  • 21