Re: First date of a month

select to_char (last_day (add_months (sysdate, -1)) + 1, 'dd-mon-yyyy') from dual;

HTH Helen

Norazman (norazman_at_ti.com) 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

: azman
Received on Tue Feb 22 2000 - 05:27:48 CST