From: "Ben Newman" <ben@no.spam.velara.com>
Newsgroups: comp.databases.oracle
Subject: date question
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <Mfme6.3328$CQ4.311867@monger.newsread.com>
Date: Thu, 01 Feb 2001 23:25:32 GMT
NNTP-Posting-Host: 209.212.133.235
X-Complaints-To: Abuse Role <abuse@fdt.net>, We Care <abuse@newsread.com>
X-Trace: monger.newsread.com 981069932 209.212.133.235 (Thu, 01 Feb 2001 18:25:32 EST)
NNTP-Posting-Date: Thu, 01 Feb 2001 18:25:32 EST
Organization: Florida Digital Turnpike (fdt.net)


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