| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Don Baccus <dhogaza(at)pacifier(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: day of week |
| Date: | 2000-06-13 02:27:37 |
| Message-ID: | 39459C19.F283099F@alumni.caltech.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> You probably right. I belive that Thomas say more about it...
to_char() is compatible with Oracle. date_part() is compatible with
Ingres (or should be). I've got the docs somewhere, but presumably I
looked at them when implementing this in the first place. Maybe not;
what I have is compatible with Unix date formatting.
> For PG date_part/trunc will SET (or anything like this) good.
Let's decide what these functions are for; in this case they are each
cribbed from an existing database product, and should be compatible with
those products imho.
btw, the "week of year" issue is quite a bit more complex; it is defined
in ISO-8601 and it does not correspond directly to a "Jan 1" point in
the calendar.
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-06-13 02:29:01 | Re: Notice in logg file |
| Previous Message | Thomas Lockhart | 2000-06-13 02:03:57 | Re: ODBC configure |