Home 2017 October SQL Puzzle: SQL Advance Query – Find number of days of the Month of any date

SQL Puzzle: SQL Advance Query – Find number of days of the Month of any date

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input date and expected output to find the total number of days in the month of given date.

Input Date Date:

Expected Output:

Solution:

Please try the different solution for this puzzle and share it via comment...

Anvesh Patel
SQL Puzzle: SQL Advance Query - Find number the first day of Quarter of YearSQL Puzzle: SQL Advance Query - Find second highest salary for each department
Comments: 4
  1. Dinesh.IS
    October 13, 2017 at 9:59 am

    DECLARE @InputDate DateTime = ‘2017-5-1’
    Select DateDiff(Day,@InputDate-Day(@InPutDate),DateAdd(Month,1,@InPutDate)-Day(@InputDate)) As NumberOfDays

    ReplyCancel
  2. OM SHAKYA
    November 16, 2017 at 3:20 am

    DECLARE @InputDate DATE = ‘2020-02-01’
    ,@FirstDate DATE
    ,@LastDate DATE

    SELECT @FirstDate = EOMONTH(@InputDate)
    SELECT @LastDate = DATEADD(mm, DATEDIFF(mm, 0, @InputDate), 0)
    SELECT DATEDIFF(DAY, @LastDate, @FirstDate) + 1 AS NoOfDaysInMonth

    ReplyCancel
  3. Ram
    August 17, 2018 at 5:47 pm

    DECLARE @InputDate DateTime = ‘2018-06-17’
    DECLARE @FirstDate DateTime
    select Day(@InPutDate)
    Set @FirstDate = @InputDate-Day(@InPutDate)
    select DATEDIFF(Day,@FirstDate,EOMonth(@InputDate))

    ReplyCancel
  4. serg
    December 25, 2019 at 9:49 pm

    declare @d as date
    set @d=’2017-8-08′

    select day(EOMONTH(@d))

    ReplyCancel

Leave a Reply to Dinesh.IS Cancel reply

CAPTCHA

*

Anvesh Patel
Anvesh Patel

Database Engineer

October 12, 2017 4 Comments SQL Puzzle, , , , , , , , , ,