Re: Dates - control how stored?

As others have no doubt pointed out by now, a DATE field in an Oracle database has a pre-defined, fixed format that reflects the century,year,month,day,hour,second

The To_Date function is to tell Oracle what format INCOMING date data is in ( 'MM/DD/YYYY' for instance for To_date('11/11/1999','MM/DD/YYYY') ) this is then stored in Oracle's DATE format...( the counterpoint is the To_Char function which formats DATE data OUTGOING , i.e. to_char(mydate_field_in_Oracle,'DD-MON-YYYY') which will output 23-MAR-1999 )

hth

hmerrill_at_my-deja.com wrote:

>We are running Oracle 8i Enterprise on Linux, and are pretty new to
>Oracle. Can you alter the way dates are stored in the database? Is
>there a TO_DATE function(if there is, where can I find online
>documenation for it?), and can that be used to alter the format that a
>date is stored in Oracle?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Dec 22 1999 - 13:12:27 CST