DVS,
> a column in one of my tables contains dates in the format yyyy-mm-dd
> From these dates I need to find out which dates are sundays.
> can anyone help me????
> PLEASE???
SELECT extract(dow from <date field>)
I believe that 0 is sunday.
--
-Josh BerkusAglio Database SolutionsSan Francisco