MySQL Forums :: Oracle :: how to show time

Advanced Search

how to show time
Posted by: michaelev05 ()
Date: March 03, 2006 12:08PM

Hiya, I've been working with oracle and I'm really having trouble creating a column that stores time. I mean time as in clock time like 12:03 for example and *without* the date.

I can use timestamps but that comes with a date. I've read about a datatype called time but everytime I try to create one, oracle says that the datatype doesnt exist. Is there anyway I can do this? Anyway at all?

Thanks a lot

Options: ReplyQuote

Subject Views Written By Posted
how to show time 6853 michaelev05 03/03/2006 12:08PM
Re: how to show time 2585 Roland Bouman 03/07/2006 02:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.