From 4b1a35b3c2e8ca4baf0199b2115fc77126aa0e2e Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter_e@gmx.net>
Date: Tue, 16 Dec 2003 15:27:58 +0000
Subject: [PATCH] Add example for converting epoch back to timestamp.

---
 doc/src/sgml/func.sgml | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index d73199fb20..5724b9b256 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.181 2003/12/13 23:59:06 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.182 2003/12/16 15:27:58 petere Exp $
 PostgreSQL documentation
 -->
 
@@ -5005,6 +5005,15 @@ SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08');
 
 SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
 <lineannotation>Result: </lineannotation><computeroutput>442800</computeroutput>
+</screen>
+
+       <para>
+        Here is how you can convert an epoch value back to a time
+        stamp:
+       </para>
+
+<screen>
+SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * interval '1 second';
 </screen>
       </listitem>
      </varlistentry>
-- 
2.40.0