Date_part & cast.

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.