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
