Re: Find all the dates in the calendar week? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Find all the dates in the calendar week?
Date
Msg-id Pine.LNX.4.21.0007070101410.4191-100000@localhost.localdomain
Whole thread Raw
In response to Re: Find all the dates in the calendar week?  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-general
Thomas Lockhart writes:

> I just didn't implement the corresponding "year" code at least partly
> because I wasn't sure what to call it. 'iyear' seems like a pretty good
> choice, or should it be 'isoyear'? 'year' is already used, obviously,
> and if 'iyear' is chosen then perhaps I should change 'week' to 'iweek'
> for consistancy. Comments?

Then we should probably rather change 'year' to something else. Standards
should be preferred. Out of curiosity, what's the difference between
ISO-year and proprietary-year? I can see the week-of-year thing, but the
year of a year is always constant, no?

Btw., isn't there an SQL EXTRACT function for all of this? Shouldn't we be
thinking in terms of that?

IMHO, the "Oracle-week" is pretty brain-dead. You can get that from
day-of-year % 7. The next thing they tell us is that the month of the year
is really day-of-year % 30.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Dave Smith
Date:
Subject: Re: libpq connectivity
Next
From: Travis Bauer
Date:
Subject: view permissions problem - featuer or bug?