Re: First day date of a month

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

The first day of every month is always 1. There are no months that ever start with anything except 1. However, you might try something like:

select last_day(add_months(sysdate,-1)) + 1 from dual; Received on Tue Feb 22 2000 - 17:25:16 CET