Oracle中是否有datetime数据类型 [英] Is there datetime datatype in Oracle
本文介绍了Oracle中是否有datetime数据类型的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨朋友们,
我想知道oracle是否有datetime数据类型。我只看到Date数据类型。请帮助我知道...
谢谢和问候
Vineetha.KR
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
推荐答案
数据类型DATE
具有这个最具误导性的名称,实在令人遗憾。事实上,现在是时候了,或者,如果你是日期时间(这将是更传统的,但仍然是丑陋的,因为日期时间仍然是时间)。为确保是这种情况,只需查看文档即可:
http://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#i1847 [ ^ ]。
-SA
This is really a shame that the data typeDATE
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
这篇关于Oracle中是否有datetime数据类型的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文