| Can you please tell me the exact size of date ..data type [message #268364] |
Tue, 18 September 2007 06:08  |
|
|
Can you please tell me the exact size of date ..data type
because if i will see oracle different version getting the below size... it was varying the size of date data type.. so I was confusing ..if oracle 8i date length is 7..then also we will insert more than 7 character like 09-09-2007(lengh is 10)
hire_date date--- it is showing length is 7
hire_date2 date--- it is showing length is 9
which length is correct???
if length is 7 also we are able to insert the time also..how it is possible..can u please explain me briefly..
Thanks and Regards,
Vetrivel k
[Updated on: Tue, 18 September 2007 06:10] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
