Re: First day date of a month

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

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

select TO_DATE('01-' || TO_CHAR(sysdate, 'MON-YYYY'), 'DD-MON-YYYY') from dual

Brian

--------------3F2FE730D4B00275677574F9
Content-Type: text/x-vcard; charset=us-ascii;  name="bduff.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Brian Duff
Content-Disposition: attachment;

begin:vcard
n:Duff;Brian
tel;cell:+44 (0)7712 191939
tel;work:+44 (0)118 9244901
x-mozilla-html:TRUE
url:http://wired.st-and.ac.uk/~briand
org:Oracle Corporation<br><center><IMG SRC="http://www.btinternet.com/~dubh/images/phoenix.gif"></center>;<center><font style="helvetica"><a href="http://des2000.uk.oracle.com:8002/bm_doc_4/web/obm-idx.htm">JDeveloper UML</a> Development</font></center> version:2.1
email;internet:bduff_at_uk.oracle.com
title:Software Engineer
adr;quoted-printable:;;Building 520=0D=0AOracle Parkway;Reading;Berkshire;RG6 1RA;UK fn:Brian Duff
end:vcard

--------------3F2FE730D4B00275677574F9-- Received on Wed Feb 23 2000 - 16:38:16 CET