datatype for time [message #36591] |
Wed, 05 December 2001 11:27  |
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  |
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 )
----------------------------------------------------------------------
|
|
|