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?
Ross