Oracle日期是如何实现的?是否存储为毫秒或类似的东西?
Oracle DATE将日期和时间存储到第二个.根据可用的硬件,Oracle TIMESTAMP将日期和时间存储到最多9位的亚秒精度.
两者都通过将日期和时间的各种组件以压缩二进制格式存储来实现.从Oracle Concepts Guide section on dates
Oracle uses its own internal format to
store dates. Date data is stored in
fixed-length fields of seven bytes
each,corresponding to century,year,
month,day,hour,minute,and second.