how to do date difference data between event date and current date - X days with lesser execution time.
Dear community,
In the database there is a packaged date attribute column that is in the string format. we need to fetch list of rows between from - 230 to - 210 days (for example: from 29-02-2024 to 21-03-2024) to current date. we have a solution but in our database millions of data. It is taking around 3 mints to retrieve the data from the query activity, Is there any possibilities to reduce the query execution time?
It would be grate if I get the solution.
Regards
Satya
Hello @chandanasa
The way you are doing it is correct. The query is slow because of data type conversion.
Related Conversations
