| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
| 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:19:48 |
| Message-ID: | Pine.LNX.3.96.1000706160833.15152A-100000@ara.zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 6 Jul 2000, Thomas Lockhart wrote:
> > ISO-week: week that has more than 4 day and start in Sunday.
> > In future I try implement 'IW' that is ISO-week, but now I work on different
> > things.
> > In current 7.0 is probably better for week operations use
> > date_part('week', TIMESTAMP) than to_char().
>
> Note that the above returns ISO-week, not some Sun-Sat thing ('dow' ==
> "day of week" does that). I haven't yet implemented ISO-year (Karel?)
> which would seem to be an essential piece to use ISO-week effectively.
>
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?
But freely, I not pursue after date/time operations and calculations, it is
"alchemy" (I admire you Thomas)... I must between work on to_char() insert
work on some other things :-)
Karel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-06 14:22:55 | Re: lztext and compression ratios... |
| Previous Message | Ron Peterson | 2000-07-06 14:19:41 | Re: proposed improvements to PostgreSQL license |