Click here to Skip to main content
15,849,829 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
Hi friends,
I would like to know whether oracle has datetime datatype.I only see Date Datatype. Please help me to know...

Thanks & Regards
Vineetha.K.R
Posted
Comments
Sergey Alexandrovich Kryukov 4-Feb-13 3:22am    
And how about just reading the documentation? :-)
—SA

1 solution

This is really a shame that the data type DATE has this most misleading name. In fact, it is time, or, if you will date-time (which would be more traditional, but still ugly, because date-time is still time). To make sure it is the case, it's enough to see the documentation:
http://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#i1847[^].

—SA
 
Share this answer
 
Comments
Mehdi Gholam 4-Feb-13 3:24am    
my 5! :)
Sergey Alexandrovich Kryukov 4-Feb-13 3:28am    
Thank you. Mehdi.
—SA
Vineetha Ravindranath 4-Feb-13 4:02am    
I want to save data as ' 2013-02-01 17:14:05.097' (in this format). How it can make possible....
Sergey Alexandrovich Kryukov 4-Feb-13 4:07am    
OK, read the article I referenced again. It has a code sample...
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900