Re: PL SQL - how to get the first day of the week

Hi

Here is a very simple way to do it:

select TO_CHAR(TRUNC(sysdate,'DAY'),'DDMMYYYY') from dual;

But remember that NLS_LANG affects to the result. (First day can be Sunday or Monday)

regards Kari
(Mr.) Kari Pannila

      Oracle DBA

--

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.


Carsten Jacobs wrote:



> Hi there,

>

> does anybody has a PL/SQL function which returns for a given date the

> date of the first day of the belonging week.

>

> Thanks for hints

>

> Carsten

> --

>

> The information transmitted is intended only for the person or entity to

> which it is addressed and may contain confidential and/or privileged

> material.  Any review, retransmission, dissemination or other use of, or

> taking of any action in reliance upon, this information by persons or

> entities other than the intended recipient is

> prohibited. If you received this in error, please contact the sender and

> delete the material from any computer.