Re: Find all the dates in the calendar week?
От | Peter Eisentraut |
---|---|
Тема | Re: Find all the dates in the calendar week? |
Дата | |
Msg-id | Pine.LNX.4.21.0007070101410.4191-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Find all the dates in the calendar week? (Thomas Lockhart <lockhart@alumni.caltech.edu>) |
Список | 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 по дате отправления: