Oracle中是否有datetime数据类型 [英] Is there datetime datatype in Oracle

问题描述

嗨朋友们，

我想知道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 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

这篇关于Oracle中是否有datetime数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！