Hi All,
I have a requirement to fetch the last sunday for a given year and month.
here is the example;
If I pass the year 2017 & Oct 29th as 29th is the last sunday in the month, I need to get the result of 30 oct 2016, because last sunday in a month of oct for the year 2016 is 30 oct 2016.
Please help me with the sql query. Thanks a lot in advance.
Thanks,
Babu.