Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dates - control how stored?

Re: Dates - control how stored?

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Wed, 22 Dec 1999 16:32:39 -0000
Message-ID: <83quhk$d0b$1@kermit.esat.net>


You can control how the dates are viewed, ie in what format. The functions you need are to_char and to_date.

hmerrill_at_my-deja.com wrote in message <83qquc$nt7$1_at_nnrp1.deja.com>...
>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.
Received on Wed Dec 22 1999 - 10:32:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US