Andrew Chernow <[EMAIL PROTECTED]> writes:
> Looks like a difference in calendars: I think the docs give the starting
> date in Julian proleptic Calendar while to_char returns Gregorian
> proleptic Calendar.
Yeah. We're definitely using Gregorian counting, because we're omitting
leap years at m
Pavel Stehule wrote:
On 14/12/2007, Andrew Chernow <[EMAIL PROTECTED]> wrote:
Ran across something that is confusing me. The docs for to_char
indicates that julian day 0 is January 1, 4712 BC at midnight.
http://www.postgresql.org/docs/8.3/static/functions-formatting.html
When I run to_char,
On 14/12/2007, Andrew Chernow <[EMAIL PROTECTED]> wrote:
> Ran across something that is confusing me. The docs for to_char
> indicates that julian day 0 is January 1, 4712 BC at midnight.
>
> http://www.postgresql.org/docs/8.3/static/functions-formatting.html
>
> When I run to_char, I don't get 0
Ran across something that is confusing me. The docs for to_char
indicates that julian day 0 is January 1, 4712 BC at midnight.
http://www.postgresql.org/docs/8.3/static/functions-formatting.html
When I run to_char, I don't get 0 for that date.
postgres=# select to_char('4712-01-01 BC'::date,
