how to Get the First day of working week in informix

Goren Amir · #1 (**permalink**) 07-13-09, 00:18

Hi All,
I'm Trying to get the First day of working Week.
( In my case, Sunday )

Any suggestion ?

Tnx.

Chrys777 · #2 (**permalink**) 07-13-09, 03:47

What exactly do you mean Goren? To perform something when the day is Sunday?

This tutorial on date processing and this example that calculates work days might help you.

Goren Amir · #3 (**permalink**) 07-13-09, 04:15

I want to automate date selection, so I can use it in Procedures and reports.

I need something like: MDY(MONTH(TODAY), 1, YEAR(TODAY))
( The first day of the current month ), but for a week.

bigcalm · #4 (**permalink**) 07-13-09, 05:25

Are you just looking for the weekday() function?

eg..

select weekday(call_date), call_date
from calls
;
-- or --
select *
from calls
where weekday(call_date) = 1
;
-- 0 = sunday, 6 = saturday.

Goren Amir · #5 (**permalink**) 07-22-09, 01:44

Tnx a lot.

Internet Services

Web Development

Digital Marketing

Consumer Tech