Re: First day date of a month
From: Loki <geen.rotzooi_at_voor.mij>
Date: Tue, 22 Feb 2000 11:40:23 +0100
Message-ID: <38B26797.BD410838_at_voor.mij>
FROM dual;
Date: Tue, 22 Feb 2000 11:40:23 +0100
Message-ID: <38B26797.BD410838_at_voor.mij>
Use:
SELECT TRUNC(sysdate, 'MM')
FROM dual;
or
SELECT TO_DATE('01-'||TO_CHAR(sysdate, 'MM-YYYY')
,'DD-MM-YYYY'
)
FROM dual;
succes!
Norazman wrote:
>
> Hi how to get the firts day date of the month in SQL.
> Ie since today is feb so it should be 01-feb-2000
> thanks
Received on Tue Feb 22 2000 - 11:40:23 CET