Date_part & cast. - Mailing list pgsql-sql

Hi,

We use PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3, and we get the following results with date_part
:

db=> select date_part( 'dow', date '20000421' );
date_part
---------       5
(1 row)

db=> select date_part( 'dow', date ( '20000421' ) );
date_part
---------       6
(1 row)

Is this correct ? If yes, I could not find any explanation for the second result which also differ from "select
date_part('dow', date (20000421)  );"
 

Thanks for any help,

-Benoit Brodard.