MySQL Forums
Forum List  »  Oracle

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

Written By
how to show time
March 03, 2006 12:08PM
March 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.