Get last day of a given month in SQL Server

-

One way to find the last day of a given month is to get the next month’s first day and then get the previous day of the particular day. The complete SQL query has given below. The query is not much complex but you may need to do some date calculation here. The query can be written as:


declare @mm varchar(2), @yy varchar(4), @dd varchar(2), @date datetime
set @date=convert(datetime, '4/16/2012')
Set @mm=(Select datepart(M, @date))
Set @yy=(Select datepart(YYYY, @date))
Set @dd= (Select Day(DATEADD(month, 1, DateAdd(day, 1-day(@date), @date))-1))
Select DATENAME(DW, ''+@mm+'/'+@dd+'/'+@yy+'')


Output:

For: 4/16/2012 :- Monday
For: 5/16/2012:- Thursday
etc..

Comments

Post a Comment

Popular posts from this blog

A new threat to users on “Incoming Calls” – VISHING

-
Image
VISHING – a new way of hacking people, to steal amount from their bank account, credit card and similar. Recently, some people received a call on their mobile phone and affected. They lost approx. Rs. 80,000 within 05 minutes from their personal credit card account. This communication is to inform you and understand the scam to safeguard yourself. VISHING calls are drastically increased across India due to no/less awareness on this fraud. VISHING (Phishing through Voice) is a verbal communication (e.g. VOIP or phone calls) used by an unauthorized person "pretending" to be from reputable bank/company. Their aim is to manipulate individuals into revealing financial information or transferring money to them. How it happens? Hacker obtains information from various sources, e.g. social media, e-commerce sites, leaked database, unsecured app installed in user phone etc. Hacker calls victim and pretends to be an official from reputed organization, e.g. bank
Read more

Session Storage - a client-side state management technique

-
In web application development, storing values in client side has limited options and those have their own limitations. For example, it can be hard to store data manipulated using web scripting languages as jQuery, JavaScript etc. Most of the time user prefer to store such data in session variable, to avoid overhead calculation of data or reading it again from repository. HTML5 has introduced additional client-side state management variable called “session storage”. This is supportable to the browser which does support HTML5, as IE 8/above, Firefox 3/above, Safari 4/above etc. Session storage can store string type of variable in client side in simple and easy steps. Reading and writing in to session storage is quite simple. An example is shown below, please note the code is written using jQuery. Set a value in session storage: sessionStorage.setItem( "name" , “ Navin Pandit ”); Read a value from session storage: sessionStorage.getItem( "name&q
Read more

HTTP Error 500.21 - Internal Server Error: ExtensionlessUrlHandler-ISAPI-4.0_32 bit has a bad module

-
Image
HTTP Error 500.21 - Internal Server Error Handler "ExtensionlessUrlHandler-ISAPI-4.0_32bit" has a bad module "IsapiModule" in its module list Solution: By changing following settings with IIS and .config file, you can fix this issue. Step: 1. Reorder the handlers in your .config file and make ExtensionlessUrlHandler-ISAPI-4.0_64bit as default.                                                   Step: 2. Set framework version to "ASP.Net v4.0" in application pool it has assigned. I could resolved my issue with these two changes.
Read more