| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
| Cc: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, Andrew Snow <als(at)fl(dot)net(dot)au>, Stephane Bortzmeyer <bortzmeyer(at)pasteur(dot)fr>, "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Find all the dates in the calendar week? |
| Date: | 2000-07-07 16:16:03 |
| Message-ID: | Pine.LNX.4.21.0007070101410.4191-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yves Dorfsman | 2000-07-07 16:19:44 | raw devices |
| Previous Message | Dave Smith | 2000-07-07 16:04:17 | Re: libpq connectivity |