Home » Developer & Programmer » Forms » Can you please tell me the exact size of date ..data type
Can you please tell me the exact size of date ..data type [message #268364] Tue, 18 September 2007 06:08 Go to next message
victoryhendry
Messages: 95
Registered: January 2007
Location: Bangalore
Member

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

Re: Can you please tell me the exact size of date ..data type [message #268400 is a reply to message #268364] Tue, 18 September 2007 07:47 Go to previous message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

Have a read of this topic
what is the size of date datatype?

It explains the differences.
Previous Topic: How to use Hierarchical tree in Form 6i
Next Topic: Help on Installing and Running Forms10g & Reports10g
Goto Forum:
  


Current Time: Sat Dec 10 06:52:49 CST 2016

Total time taken to generate the page: 0.13103 seconds