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 | 824df1cccb74f5f634439ecf6c9828fea6ecc3ef (patch) | |
| tree | e7f602d5b022c14d86b65cc9996dc8c313f0cb7f | |
| parent | 85a3e0be1e94b4e0e94d1480f43fe47ce7f68b62 (diff) | |
| download | postgresql-824df1cccb74f5f634439ecf6c9828fea6ecc3ef.tar.gz postgresql-824df1cccb74f5f634439ecf6c9828fea6ecc3ef.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 b543f64b651..b2f29e62284 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> |