Re: Last_Day...but is there a First_Day?

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 27 Sep 1999 07:02:18 GMT
Message-ID: <01bf08b5$cdae05a0$190114c1@sister.grant.UUCP>

ramsey84_at_my-deja.com wrote in article <7sjjhb$if6$1_at_nnrp1.deja.com>...
: Does anyone know the best way to return the first day of the month
for
: a date field.

trunc(Your_Date, 'mm')
--
Alexander I.Doroshko, aid_at_grant.kharkov.ua

Bank "Grant", Kharkov, Ukraine

Received on Mon Sep 27 1999 - 02:02:18 CDT

This message: [ Message body ]
Next message: ÃÖ»ó¼ø: "I want to know how many times comma(,) appear in string ..."
Previous message: Thomas Kyte: "Re: Oracle 8i, A very basic question"
In reply to: ramsey84_at_my-deja.com: "Last_Day...but is there a First_Day?"

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