Re: date question

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...


> 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

>

>