"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:uo$h$uHWDHA.548@tk2msftngp13.phx.gbl...
> 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" <gennadyb@genuscap.com> wrote in message
> news:evBWa.33306$LD6.348175@news0.telusplanet.net...
> > 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 Besfamilny" <gennadyb@genuscap.com> wrote in message
news:evBWa.33306$LD6.348175@news0.telusplanet.net...
> 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
>
>