Re: date question
From: Jim Kennedy <kennedy-family_at_home.com>
Date: Fri, 02 Feb 2001 01:07:19 GMT
Message-ID: <bLne6.358132$U46.10668298_at_news1.sttls1.wa.home.com>
Date: Fri, 02 Feb 2001 01:07:19 GMT
Message-ID: <bLne6.358132$U46.10668298_at_news1.sttls1.wa.home.com>
You could choose to just use the month and day. You could make your own data type that consisted of a month and a day . But a date inherently has a year.
To select just the day and month you can do:
select to_char(myDateColumn,'mm/dd') from myTable;
Jim
-- "Ben Newman" <ben_at_no.spam.velara.com> wrote in message news:Mfme6.3328$CQ4.311867_at_monger.newsread.com...Received on Fri Feb 02 2001 - 02:07:19 CET
> I am new to Oracle's implementation of SQL, and I have a very basic
question
> regarding the "date" data type.
>
> The documentation indicates that Oracle stores the century down to the
> second for a date, but suppose I only care about the current month and
day.
> How can I adjust either the way the data is stored or retrieved from the
> column?
>
> --ben
>
>