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: Date Datatype

Re: Date Datatype

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: 1998/10/09
Message-ID: <6vkrfm$b9b$1@schbbs.mot.com>#1/1

Simply take your time (presumably as a string) and convert to a date type using only a time format mask. You can then store your time in Oracle DATE type. You will have a date 'attached' to the value for storage (SYSDATE?) but as long as when you read it back you do so only with a time format then you'll be OK.

--
Alan D. Mills


Nimat Haque wrote in message <361D514F.780076C8_at_ece2.engr.ucf.edu>...

>Hi,
>Is there any way to save time into Oracle database like it can be done
>in Ms Access. Simplest solution I can think of is to save it as a
>varchar. But I am looking forward to a better solution.
>
>-Nimat
>
Received on Fri Oct 09 1998 - 00:00:00 CDT

Original text of this message

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