[BUGS] RE: DATE_PART() BUG? We have an SQL statement that is giving wrong output.

Thanks! That did it: tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth; dayofmonth 31 (1 row) tbs=# SET TIMEZONE = 'GMT' ; SET VARIABLE tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth; dayofmonth 1 (1 r

[BUGS] DATE_PART() BUG?

er varying(7), "purchasedate" date, "emailaddress" character varying(60), "firstname" character varying(25), "lastname" character varying(50), "customerfullname" character varying(40), "salesordernumber&qu