Hi

I am new to informix,
I want to find date of first sunday on a given month, we have next_day function in oracle, is there any funtion like this in informix?
sql query which return the date of first sunday will be help full.

thanks
ashok

There is no function to do this but you can use the WEEKDAY() function and derive the value. For example:

select first 1 case weekday('03/01/2004')
when 0 then 1
else (8 - weekday('03/01/2004'))
end
from systables;

The date you would supply is the 1st of the month in question.