Re: [SQL] Problem with Day of Week

[Ross J. Reedstrom]

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