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 | c93f8f3b8d3bc780892e2bf11192fbdd136fddfe (patch) | |
| tree | 74d6c29823ac136c5032180742f6b6a753e5bcb8 | |
| parent | f93f0b5b25068807051edb2f3510614b69bb79ff (diff) | |
| download | postgresql-c93f8f3b8d3bc780892e2bf11192fbdd136fddfe.tar.gz postgresql-c93f8f3b8d3bc780892e2bf11192fbdd136fddfe.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 2e48d5d7885..c53bd2f379f 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -908,22 +908,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'); extract ------------------------------ - 2459389.95833333333333333333 + 2459388.95833333333333333333 (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'); extract -------------------------------------- - 2459390.0000000000000000000000000000 + 2459389.0000000000000000000000000000 (1 row) -=> SELECT extract(julian from date '2021-06-24'); +=> SELECT extract(julian from date '2021-06-23'); extract --------- - 2459390 + 2459389 (1 row) </programlisting> </para> |