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.