Home » SQL & PL/SQL » SQL & PL/SQL » date column with format hh24:mi:ss
date column with format hh24:mi:ss [message #37966] Sun, 10 March 2002 06:05 Go to next message
Seb
Messages: 7
Registered: July 2000
Junior Member
Hello,

can i have a column date with only time values like:
hh24:mi:ss without date ?

thanks...

Report message to a moderator

Re: date column with format hh24:mi:ss [message #37970 is a reply to message #37966] Mon, 11 March 2002 05:38 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
if u are using versions 8i and below, answer is NO.
Oracle 9i has timestamp datatype. In 8i, if u want to store only time part, you have to use either varchar2 type (validation need to be done explicitly) or use date type and add some default date to it.

Report message to a moderator

Previous Topic: HOW TO LOOK UP THE CONTENT OF THE PROCEDURE?
Next Topic: website
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 08:03:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.