Re: SQL, return last sundays date...

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

select *
  from( values(
  case
  when dayofweek(current_date) = 1 then current_date
  when dayofweek(current_date) > 1 and year(current_date -
(DAYOFWEEK(current_date)
- 1) DAYS) = year(current_date) then current_date - (DAYOFWEEK(current_date)
- 1) DAYS
  else date(year(current_date) concat '-01-01')
  end)) t ("Last Sunday") ;


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144

Please consider sponsoring me for the Friends For Life Bike Rally
<https://secure.e2rm.com/registrant/FundraisingPage.aspx?SID=5323935&LangPref=en-CA>
in support of the Toronto People with AIDS Foundation.


On 29 June 2015 at 17:29, Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
wrote:

> yes. that is what I need...
>
>
> On Mon, Jun 29, 2015 at 4:28 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
> wrote:
>
> > On Mon, Jun 29, 2015 at 4:54 PM, Gerald Magnuson
> > <gmagqcy.midrange@xxxxxxxxx> wrote:
> > > now I just need to figure out how to get the beginning of week, when
> end
> > is
> > > < 01-07...
> >
> > Like Charles, I don't know what you mean by this.
> >
> > But I will take a stab. My guess is that when the "input date" is too
> > close to the beginning of the year (so that there is no previous
> > Sunday in that year), you want to instead return Jan 1 of that year.
> >
> > John Y.