Get Last Day Of Month

>>Script Language and Platform: MS SQL Server

This script will get the last day of the month.

Author: Ram Ramamoorthy

SELECT     (CASE   MONTH(GETDATE())

                WHEN 1 THEN 31

                WHEN 2 THEN (CASE YEAR(GETDATE())%4 WHEN 0 THEN 29 ELSE 28 END)

                WHEN 3 THEN 31

                WHEN 4 THEN 30

                WHEN 5 THEN 31

                WHEN 6 THEN 30

                WHEN 7 THEN 31

                WHEN 8 THEN 31

                WHEN 9 THEN 30

                WHEN 10 THEN 31

                WHEN 11 THEN 30

                WHEN 12 THEN 31

        END) AS LastDayOfMonth

Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
“as -is”, without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose…

Disclaimer Continued

Back to Database Journal Home