17.07.2001 16:59:33, Thomas Lockhart <lockhart@fourpalms.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