| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | 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-06 14:35:33 |
| Message-ID: | 39649935.6CE3056A@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> yes, my current to_char() is almost compatible with oracle, but I need
> last two features --- IYYY (ISO-year) and IW (ISO-week). But I not explore
> it exactly yet. I mean that current (PG's) week-of-year is like ISO or not?
Yes. 'week' is "ISO week" (new for 7.0 afaicr). And it wasn't *entirely*
trivial to implement, so you may want to steal code for to_char() ;)
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?
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-06 14:39:06 | Re: PostgreSQL & the BSD License |
| Previous Message | Niraj Bhatt | 2000-07-06 14:29:47 | A Referntial integrity |