Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

storing just time, no date

732674Nov 24 2009 — edited Nov 24 2009

I am trying to store times like 8:00:00 or 14:30:00, but no dates in one of my tables.

I have the column datatype set to DATE right now and tried INSERT INTO periods VALUES(to_date('08:00:00', 'hh24:mi:ss'), but when I ran a select query on this table i got back 1-Nov-09. Is it not possible to store just time? Or is there a better way or datatype that i am missing?

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2009

Added on Nov 24 2009

#general-database-discussions

6 comments

1,369 views