(select Extract(dow...))

Bot44

Hi all

Does anyone know how to subtract the day of the week (in numbers)
from the current date

i tried

....(current_date + (SELECT EXTRACT(DOW FROM current_timestamp)))

but got stupid syntax errors?

rski

i'm afraid my english isn't good enough but writting

Expand|Select|Wrap|Line Numbers

select extract(dow from '30-08-2008'::date);

you get a number representation of saturday (ie number 6).

I'm afraid it isn't what you need because you use similar query, so if you could specify what you need.

(select Extract(dow...))

re: (select Extract(dow...))

/bytes/development

/bytes/it

/bytes/about