Commitc93f8f3

committed

Doc: fix discussion of how to get real Julian Dates.

Somehow I'd convinced myself that rotating to UTC-12 was the wayto do this, but upon further review, it's definitely UTC+12.Discussion:https://postgr.es/m/1197050.1619123213@sss.pgh.pa.us

1 parentf93f0b5 commitc93f8f3Copy full SHA for c93f8f3

File tree

-7

lines changed

-7

lines changed

Lines changed: 7 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -908,22 +908,22 @@ $ <userinput>cal 9 1752</userinput>`
`908`	`908`	`<para>`
`909`	`909`	`This definition does, however, provide a way to obtain the astronomical`
`910`	`910`	`definition when you need it: do the arithmetic in time`
`911`		`- zone <literal>UTC-12</literal>. For example,`
	`911`	`+ zone <literal>UTC+12</literal>. For example,`
`912`	`912`	`<programlisting>`
`913`		`-=> SELECT extract(julian from '2021-06-23 7:00:00-04'::timestamptz at time zone 'UTC-12');`
	`913`	`+=> SELECT extract(julian from '2021-06-23 7:00:00-04'::timestamptz at time zone 'UTC+12');`
`914`	`914`	`extract`
`915`	`915`	`------------------------------`
`916`		`-2459389.95833333333333333333`
	`916`	`+2459388.95833333333333333333`
`917`	`917`	`(1 row)`
`918`		`-=> SELECT extract(julian from '2021-06-23 8:00:00-04'::timestamptz at time zone 'UTC-12');`
	`918`	`+=> SELECT extract(julian from '2021-06-23 8:00:00-04'::timestamptz at time zone 'UTC+12');`
`919`	`919`	`extract`
`920`	`920`	`--------------------------------------`
`921`		`-2459390.0000000000000000000000000000`
	`921`	`+2459389.0000000000000000000000000000`
`922`	`922`	`(1 row)`
`923`		`-=> SELECT extract(julian from date '2021-06-24');`
	`923`	`+=> SELECT extract(julian from date '2021-06-23');`
`924`	`924`	`extract`
`925`	`925`	`---------`
`926`		`-2459390`
	`926`	`+2459389`
`927`	`927`	`(1 row)`
`928`	`928`	`</programlisting>`
`929`	`929`	`</para>`

Comments

(0)