Re: Problem with Day of Week

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