1st Day of the Month - SQL*Plus

[aph]

Hi All,

How I can get the 1st day of the month, I mean let's say today date is 20-JUL-05 and I need 01-JUL-05.

Thanks in advance

[aph]

No problem; I got it. below is the solution

SELECT '01-'||to_char(sysdate,'MON-YY') FROM DUAL

[eddieawad]

No problem; I got it. below is the solution

SELECT '01-'||to_char(sysdate,'MON-YY') FROM DUAL

Here is a more elegant yet simple solution that returns a date instead of a string:

select trunc(sysdate,'mon') first_of_month 
from dual

If you still want the date as a formatted string:

select to_char(trunc(sysdate,'mon'),'DD-MON-YY') first_of_month 
from dual