Hello PG's,
I want to extract the weekday of a given 'date' type field in my table
when selecting. How can I do this?
For example in a table "bschft_days" filled with values with type 'date'
I want to select all the days within the month 'march' and output the respective
weekday. I tryed this:
select extract(dow from timestamp(day)), day, userid from bschft_days where
date_part('month', day) = '3';
But it only tells me:
ERROR: parser: parse error at or near "dow"
:(
Any ideas??
Thanks a lot in advance!
Best Regards / Mit freundlichen Gr��en / Un saludo
Jos� Manuel lorenzo L�pez
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
