Re: PL/SQL Week days
From: DanHW <danhw_at_aol.com>
Date: 03 Aug 1999 05:15:57 GMT
Message-ID: <19990803011557.01161.00002610_at_ng-xc1.aol.com>
Date: 03 Aug 1999 05:15:57 GMT
Message-ID: <19990803011557.01161.00002610_at_ng-xc1.aol.com>
>A little PL/SQL question:
>
>How to check if a given date is a saturday or a sunday, staying independant
>of the NLS parameters ?
>(Oracle 8.0.5)
>
>Achille Carette
>act_at_bluegate.be
>
>
One of the date formats, I beleive it is 'D' returns 1 for Sunday... 7 for Saturday. I don't think that it depends on the NLS setting.
Dan Hekimian-Williams Received on Tue Aug 03 1999 - 07:15:57 CEST