Try one of these:extract(DOW FROM TIMESTAMP TIMESTAMP(a.startdate)) AS "dow", ERROR: parser: parse error at or near "TIMESTAMP"
extract(dow from cast(a.startdate as timestamp)) as "dow"
extract(dow from a.startdate) as "dow"
extract(dow from a.startdate::timestamp) as "dow"
I remember I had problems when migrating to Postgres 7.2. I don't remember why, but I had to convert all "timestamp" to "timestamp without time zone". Probably this was because of ZEOS-direct-access components for C++ Builder.
Regards,
Tomasz Myrta
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
