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 | 56e234b6aff9c2e3b97fe647156012b5b175680f (patch) | |
| tree | 8fe67289357e91a994ab4e90499bb9cd80fd7146 | |
| parent | b797918d27cc532b4835d87c676de34d4b9ee9bd (diff) | |
| download | postgresql-56e234b6aff9c2e3b97fe647156012b5b175680f.tar.gz postgresql-56e234b6aff9c2e3b97fe647156012b5b175680f.zip | |
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> |