From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
Cc: | Keith Perry <keith(at)vcsn(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Problem with Day of Week |
Date: | 2001-02-05 17:08:02 |
Message-ID: | Pine.LNX.3.96.1010205175827.29540K-100000@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Mon, 5 Feb 2001, Ross J. Reedstrom wrote:
> On Mon, Feb 05, 2001 at 05:15:47PM +0100, Karel Zak wrote:
> >
> > test=# select date_part('dow','2001-02-11'::timestamp);
> > date_part
> > -----------
> > 0
> >
> > test=# select to_char('2001-02-11'::timestamp, 'D');
> > to_char
> > ---------
> > 1
> >
> >
> > date_part is based on zero - use range 0-6
> > to_char is based on one - use range 1-7
> >
>
> My understanding is that one is ISO, the other is for Oracle
> compatability, is that not right Karel?
You are right, Larry Ellison use 1-7 (he must, if the PostgreSQL to_char()
is 100% comapatible :-)
I don't know if 0-6 is like ISO (Thomas?), but surely it's like POSIX.
Karel
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2001-02-05 17:12:53 | Re: Problem with Day of Week |
Previous Message | keith | 2001-02-05 16:56:49 | Re: Problem with Day of Week |