Archives of the TeradataForum

Message Posted: Wed, 08 Dec 2004 @ 17:05:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Victor Sokovin wrote:

Correct, there's no year 0.

From Oracle manual:

"Julian day; the number of days since January 1, 4712 BC. Number specified with ’J’ must be integers."

Here's the problem:

Julian day starts one year earlier, at January 1, 4713 BC. So Oracle really introduced year 0:

          BC -> wrong
          AD -> correct

Everything you ever wanted to know about calendars: Claus Tondering's Calendar FAQ at www.tondering.dk/claus/calendar.html

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>