Professional Web Applications Themes

How to get the number of days in a month? - Microsoft SQL / MS SQL Server

DECLARE d DATETIME SET d = CURRENT_TIMESTAMP SELECT DAY(DATEADD(DAY,-1,DATEADD(MONTH,1,DATEADD(DAY,1-DAY(d),d)))) AS days_in_month -- David Portas ------------ Please reply only to the newsgroup -- "Petr Stejskal" <cz> wrote in message news:phx.gbl... ...

  1. #1

    Default Re: How to get the number of days in a month?

    DECLARE d DATETIME
    SET d = CURRENT_TIMESTAMP
    SELECT DAY(DATEADD(DAY,-1,DATEADD(MONTH,1,DATEADD(DAY,1-DAY(d),d)))) AS
    days_in_month
    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Petr Stejskal" <cz> wrote in message
    news:phx.gbl... 


    David Guest

  2. #2

    Default Re: How to get the number of days in a month?

    Check out:
    http://www32.brinkster.com/srisamp/sqlArticles/article_5.htm
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Petr Stejskal" <cz> wrote in message
    news:phx.gbl... 


    SriSamp Guest

  3. #3

    Default Re: How to get the number of days in a month?

    http://www.aspfaq.com/2444




    "Petr Stejskal" <cz> wrote in message
    news:phx.gbl... 


    Aaron Guest

  4. #4

    Default Re: How to get the number of days in a month?

    Petr,

    declare month datetime
    set month = '20040201'
    select datediff(dd, month, dateadd(mm, 1, month))

    set month = '20030201'
    select datediff(dd, month, dateadd(mm, 1, month))


    Linda

    lindawie Guest

  5. #5

    Default Re: How to get the number of days in a month?

    Linda:

    This doesn't work for all dates. Try:

    declare month datetime
    set month = '20030131'
    select datediff(dd, month, dateadd(mm, 1, month))

    Vern
     
    Vern Guest

Similar Threads

  1. Getting the month by Number
    By silstorm in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: July 5th, 07:36 AM
  2. #39560 [NEW]: Inconsistent behaviour of strtotime when days > days in month
    By php at colin dot guthr dot ie in forum PHP Bugs
    Replies: 1
    Last Post: November 20th, 05:21 PM
  3. Convert month name to month number
    By G_Park in forum Macromedia ColdFusion
    Replies: 4
    Last Post: September 13th, 01:26 PM
  4. Display month and days with results
    By Andy Hassall in forum PHP Development
    Replies: 0
    Last Post: August 17th, 05:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139