Reply-To: "Jim Kennedy" From: "Jim Kennedy" Newsgroups: comp.databases.oracle References: Subject: Re: date question Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Fri, 02 Feb 2001 01:07:19 GMT NNTP-Posting-Host: 65.4.45.60 X-Complaints-To: abuse@home.net X-Trace: news1.sttls1.wa.home.com 981076039 65.4.45.60 (Thu, 01 Feb 2001 17:07:19 PST) NNTP-Posting-Date: Thu, 01 Feb 2001 17:07:19 PST Organization: Excite@Home - The Leader in Broadband http://home.com/faster 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" wrote in message news:Mfme6.3328$CQ4.311867@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 > >