Re: First date of a month

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 22 Feb 2000 10:32:05 -0500
Message-ID: <cva5bs01qo1va8qkoh5s2foie9pkpaadra@4ax.com>

A copy of this was sent to Norazman <norazman_at_ti.com> (if that email address didn't require changing) On Tue, 22 Feb 2000 18:26:33 +0800, you 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

ops$tkyte_at_dev8i> select trunc(sysdate,'month') from dual;

TRUNC(SYS

---

01-FEB-00 --
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Feb 22 2000 - 09:32:05 CST