While for one of the applications in early 2007, that I was working on in India, I had to get the daylight saving dates for that year. But during that time, we did not implement that functionality. While I was working on this problem, I tried to google and find out what could be a possible in-built function in SQL Sever to give me this result. I could not find any such kind of fucntion nor I could not find any one writing about this problem.
I decided to start my own blogs and start writing and helping the community and start learning from my peers, and the first thing that came to my mind was this unsolved problem that I had faced in early 2007. To my surprise, I did not find any solution to this problem and decided that this problem will be my first article to blog.
Please find the Query / T-SQL script below.