Re: First date of a month

From: Elrond <elrond_at_icn.pl>
Date: Tue, 22 Feb 2000 11:41:47 +0100
Message-ID: <88tpc3$el8$1@helios.man.lublin.pl>

Hmmmm I always thought the first day of the month is 1 '01'||to_char(:sysdate,'MM.YYYY')
Elrond
Uzytkownik "Norazman" <norazman_at_ti.com> napisal w wiadomosci news:38B26459.CD9CFC51_at_ti.com...
> 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 - 04:41:47 CST

This message: [ Message body ]
Next message: J. Park: "Multi-value fields in Oracle"
Previous message: Norazman: "First date of a month"
In reply to: Norazman: "First date of a month"
Next in thread: Michael Seagal: "Re: First date of a month"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US