var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to Get the First day of working week in informix
I'm Trying to get the First day of working Week.
( In my case, Sunday )
Any suggestion ?
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.
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.
Are you just looking for the weekday() function?
select weekday(call_date), call_date
-- or --
where weekday(call_date) = 1
-- 0 = sunday, 6 = saturday.