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: 96
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: :System.Mode
Next Topic: Flag Set
Goto Forum:
  


Current Time: Mon Aug 21 07:14:24 CDT 2017

Total time taken to generate the page: 0.04766 seconds