On Mon, 29 Jan 2001, Keith Perry wrote:
> Greetings,
>
> I notice some talk about date problems and interestingly enough planning
> out an application in which I will need to be able to manipulate dates.
> I notice however that there seems to be a discrepancy with the day or
> week in 7.0.3
>
> ---
>
> pmhcc=# select date_part('dow','now'::timestamp);
> date_part
> -----------
> 1
> (1 row)
>
> pmhcc=# select to_char('now'::timestamp,'D');
> to_char
> ---------
> 2
> (1 row)
>
See:
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
Karel
