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

17.07.2001 16:59:33, Thomas Lockhart <lockhart(at)fourpalms(dot)org> wrote:

>> 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';

Hello Thomas,

I tried with the quotes but it doesn't work! :(

Is this a feature for PG 7.1.x only???

Best Regards / Mit freundlichen Grüßen / Un saludo

José Manuel Lorenzo López