Re: How to find out the weekday from a date???

> I want to extract the weekday of a given 'date' type field in my table
> when selecting. How can I do this?
...
> select extract(dow from timestamp(day)), day, userid
>  from bschft_days where date_part('month', day) = '3';
...
> ERROR:  parser: parse error at or near "dow"

That seems to work on 7.1.x. Perhaps you are using an older version? In
either case, you can try putting single quotes around "dow", like

  select extract('dow' from timestamp(day)), day, userid
   from bschft_days where date_part('month', day) = '3';

hth

                      - Thomas