E.g.
create table mytable (created datetime);
insert into mytable values ('01-01-2001');
...
insert into mytable values ('01-31-2001');
select created from mytable where date_part('dow', created) = 7 and date_part('month', created) = 1;
Troy
>
> i want to select date in january where day='Sunday'
>
> any idea ??
>
> please help me
>
> Nizomi
>