Getting Last Day of Month:
-
Hi I have month and year values, I want to get last day of month. How it can be acheived in SQL server 2005?
Shahzad Aslam Software Engineer Softech Systems Limited Cell: +92-321-4606036 Email: shehzadaslam@hotmail.com
-
Hi I have month and year values, I want to get last day of month. How it can be acheived in SQL server 2005?
Shahzad Aslam Software Engineer Softech Systems Limited Cell: +92-321-4606036 Email: shehzadaslam@hotmail.com
-
Try one of them...... 1. SELECT Datepart(dd,DateAdd(day, -1, DateAdd(month, DateDiff(month, 0, Getdate())+1, 0))) 2. Select datepart(dd,dateadd(mm,1,Getdate() - day(Getdate()))) have a nice time........
Thanx!!!
Shahzad Aslam Software Engineer Softech Systems Limited Cell: +92-321-4606036 Email: shehzadaslam@hotmail.com