Home » SQL & PL/SQL » SQL & PL/SQL » datatype for time
datatype for time [message #36591] Wed, 05 December 2001 11:27 Go to next message
ghazala
Messages: 6
Registered: December 2001
Junior Member
like creating a column for addmission_date datatype is "date", what wiil be the datatype for column "addmission_time".

----------------------------------------------------------------------
Re: datatype for time [message #36593 is a reply to message #36591] Wed, 05 December 2001 11:38 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
There is no time datatype in oracle. oracle stores date with time. (even when you didnt specify time as part of date oracle stores date+00:00:00 time )

----------------------------------------------------------------------
Previous Topic: white
Next Topic: How can I get multiple records from store procedure?
Goto Forum:
  


Current Time: Fri Jun 05 15:20:46 CDT 2020