diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2021-04-28 10:03:28 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2021-04-28 10:03:28 -0400 |
| commit | f6171e6843f028aff27edd8f5e54bb7777d80045 (patch) | |
| tree | 82f7eed82f9306106ee65d23c41cd050038e1058 | |
| parent | 0d05a3a1df4f0f6ab3341dae77da633f2df75cec (diff) | |
Doc: fix discussion of how to get real Julian Dates.
Somehow I'd convinced myself that rotating to UTC-12 was the way
to do this, but upon further review, it's definitely UTC+12.
Discussion: https://postgr.es/m/1197050.1619123213@sss.pgh.pa.us
| -rw-r--r-- | doc/src/sgml/datetime.sgml | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/datetime.sgml b/doc/src/sgml/datetime.sgml index d9666ebe7d9..dec64a51387 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -930,22 +930,22 @@ $ <userinput>cal 9 1752</userinput> <para> This definition does, however, provide a way to obtain the astronomical definition when you need it: do the arithmetic in time - zone <literal>UTC-12</literal>. For example, + zone <literal>UTC+12</literal>. For example, <programlisting> -=> SELECT extract(julian from '2021-06-23 7:00:00-04'::timestamptz at time zone 'UTC-12'); +=> SELECT extract(julian from '2021-06-23 7:00:00-04'::timestamptz at time zone 'UTC+12'); date_part -------------------- - 2459389.9583333335 + 2459388.9583333335 (1 row) -=> SELECT extract(julian from '2021-06-23 8:00:00-04'::timestamptz at time zone 'UTC-12'); +=> SELECT extract(julian from '2021-06-23 8:00:00-04'::timestamptz at time zone 'UTC+12'); date_part ----------- - 2459390 + 2459389 (1 row) -=> SELECT extract(julian from date '2021-06-24'); +=> SELECT extract(julian from date '2021-06-23'); date_part ----------- - 2459390 + 2459389 (1 row) </programlisting> </para> |