Jumping Weekends
Hello,
(sorry for my poor english)
It's my first post here, and my doubt is very simple (I guess). I have a
function to populate a table, into "WHILE" I have the follow piece of code:
--Jump Weekend
IF (SELECT TO_CHAR(CAST(PRODUCTION_DATE as date),'Day')) = 'Saturday' THEN
PRODUCTION_DATE := PRODUCTION_DATE + 2;
END IF;
It's to jump weekend adding 2 days on the variable "PRODUCTION_DATE",
the type of the variable is "DATE". But, I don't know why, it's doesn't
work properly, it's doesn't jump weekends, it's continues normally,
someone knows what's happen or what am I doing wrong?
I appreciate any help.
Thanks
Ranieri Mazili
Hello,
you forgot on sunday. Your solution can work, but isn't too efective
you can do:
production_date := production_date +
CASE extract(dow from production_date)
WHEN 0 THEN 1 -- sunday
WHEN 6 THEN 2 -- saturday
ELSE 0 END;
there isn't slower string comparation and it's one sql statement without two.
Regards
Pavel Stehule
2007/6/4, Ranieri Mazili <ranieri.oliveira@terra.com.br>:
Show quoted text
Hello,
(sorry for my poor english)It's my first post here, and my doubt is very simple (I guess). I have a
function to populate a table, into "WHILE" I have the follow piece of code:--Jump Weekend
IF (SELECT TO_CHAR(CAST(PRODUCTION_DATE as date),'Day')) = 'Saturday' THEN
PRODUCTION_DATE := PRODUCTION_DATE + 2;
END IF;It's to jump weekend adding 2 days on the variable "PRODUCTION_DATE",
the type of the variable is "DATE". But, I don't know why, it's doesn't
work properly, it's doesn't jump weekends, it's continues normally,
someone knows what's happen or what am I doing wrong?I appreciate any help.
ThanksRanieri Mazili
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?