Professional Web Applications Themes

sql for end-month data extracting - Microsoft SQL / MS SQL Server

Hello, in my table I have 2 columns: 1. "datadate" which has format "yyyy-mm-dd" and contains daily dates for 3 years. 2 . "data" - contains daily data. I need SQL statement to extract only end-month data like this: 2000-01-31 200 2000-02-28 100 2000-03-31 300 ......................................... 2003-06-30 150 Thanks, GB...

  1. #1

    Default sql for end-month data extracting

    Hello,
    in my table I have 2 columns:
    1. "datadate" which has format "yyyy-mm-dd" and contains daily dates for 3
    years.
    2 . "data" - contains daily data.

    I need SQL statement to extract only end-month data like this:
    2000-01-31 200
    2000-02-28 100
    2000-03-31 300
    .........................................
    2003-06-30 150

    Thanks,
    GB


    Gennady Guest

  2. #2

    Default Re: sql for end-month data extracting

    Assuming datadate is a DATETIME column:

    SELECT *
    FROM Sometable
    WHERE MONTH(DATEADD(DAY,1,datadate))>MONTH(datadate)

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Gennady Besfamilny" <com> wrote in message
    news:evBWa.33306$telusplanet.net... 


    David Guest

  3. #3

    Default Re: sql for end-month data extracting

    Thank you, it works in general but I still have a problem
    with dates which are non- business days - for weekends I don't have data
    values.
    For example, I don't have value for 2003-05-31 but I do have value for
    2003-05-30.
    How can I modify your query to fix this problem?

    Thanks,
    GB


    "David Portas" <org> wrote in message
    news:uo$h$phx.gbl... [/ref]

    >
    >[/ref]


    Gennady Guest

Similar Threads

  1. Extracting value from data within an element.
    By anthony in forum PERL Modules
    Replies: 1
    Last Post: December 1st, 12:12 PM
  2. Extracting Data from Datagrid
    By Joel Zinn in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: September 21st, 12:41 PM
  3. PHP Extracting day, month and year from string
    By jip in forum Dreamweaver AppDev
    Replies: 2
    Last Post: June 1st, 05:08 PM
  4. Extracting web data
    By m roberts in forum PHP Development
    Replies: 1
    Last Post: August 14th, 02:01 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