Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 7bbcfb4

Browse filesBrowse files
committed
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
1 parent a928297 commit 7bbcfb4
Copy full SHA for 7bbcfb4

File tree

Expand file treeCollapse file tree

1 file changed

+7
-7
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+7
-7
lines changed

‎doc/src/sgml/datetime.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/datetime.sgml
+7-7Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -908,22 +908,22 @@ $ <userinput>cal 9 1752</userinput>
908908
<para>
909909
This definition does, however, provide a way to obtain the astronomical
910910
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,
912912
<programlisting>
913-
=&gt; SELECT extract(julian from '2021-06-23 7:00:00-04'::timestamptz at time zone 'UTC-12');
913+
=&gt; SELECT extract(julian from '2021-06-23 7:00:00-04'::timestamptz at time zone 'UTC+12');
914914
date_part
915915
--------------------
916-
2459389.9583333335
916+
2459388.9583333335
917917
(1 row)
918-
=&gt; SELECT extract(julian from '2021-06-23 8:00:00-04'::timestamptz at time zone 'UTC-12');
918+
=&gt; SELECT extract(julian from '2021-06-23 8:00:00-04'::timestamptz at time zone 'UTC+12');
919919
date_part
920920
-----------
921-
2459390
921+
2459389
922922
(1 row)
923-
=&gt; SELECT extract(julian from date '2021-06-24');
923+
=&gt; SELECT extract(julian from date '2021-06-23');
924924
date_part
925925
-----------
926-
2459390
926+
2459389
927927
(1 row)
928928
</programlisting>
929929
</para>

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.