DATE TIME In RDBMS - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

DATE TIME In RDBMS

DATE TIME In RDBMS# Java - 爪哇娇娃

F*n2009-08-30 07:08

1 楼

Does anyone notice that most RDBMSs have unbelievable limits on Date/Time
range they support? For example, mysql only supports date from 1000-01-01,
so you cannot enter earlier dates in a Date/Time column.
What the hell are those providers thinking? Is supporting Date/Time so big
an issue that they have to resort to those stupid limits?
What the solutions most people use?

j*a2009-08-30 07:08

2 楼

Because MySQL is a free software, that is why they support like that.
Why don't you use other database?
Oracle's date range from 4712BC to 9999AD.
PostgreSQL's date range from 4713BC to 5874897AD.

【在 F****n 的大作中提到】

: Does anyone notice that most RDBMSs have unbelievable limits on Date/Time
: range they support? For example, mysql only supports date from 1000-01-01,
: so you cannot enter earlier dates in a Date/Time column.
: What the hell are those providers thinking? Is supporting Date/Time so big
: an issue that they have to resort to those stupid limits?
: What the solutions most people use?

s*n2009-08-30 07:08

3 楼

it is actually very complicated. you can see it from java date classes
http://www.docjar.com/html/api/java/util/GregorianCalendar.java.html
mysql is probably over sensitive about efficiency.

【在 F****n 的大作中提到】

F*n2009-08-30 07:08

4 楼

IMO, those RDBMS people constantly cannot understand the difference between
a date and a dateformat. Those people always try to legitimate their
implementation by spending several pages talking about Date Format. In fact
for date / time storage you only need a integer / long, and the complexity
of DateFormat can always be encapsulated in the JDBC driver (or other DB
access API).

【在 s******n 的大作中提到】

: it is actually very complicated. you can see it from java date classes
: http://www.docjar.com/html/api/java/util/GregorianCalendar.java.html
: mysql is probably over sensitive about efficiency.

c*t2009-08-30 07:08

5 楼

你说的估计一般使用可以足够。但是有些年 +/- 些 second，而如果真需要这种
resolution 的话，还真是个麻烦事。

between
fact

【在 F****n 的大作中提到】

: IMO, those RDBMS people constantly cannot understand the difference between
: a date and a dateformat. Those people always try to legitimate their
: implementation by spending several pages talking about Date Format. In fact
: for date / time storage you only need a integer / long, and the complexity
: of DateFormat can always be encapsulated in the JDBC driver (or other DB
: access API).