|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.181 2003/12/13 23:59:06 neilc Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.182 2003/12/16 15:27:58 petere Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -5005,6 +5005,15 @@ SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08'); |
5005 | 5005 |
|
5006 | 5006 | SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours'); |
5007 | 5007 | <lineannotation>Result: </lineannotation><computeroutput>442800</computeroutput> |
| 5008 | +</screen> |
| 5009 | + |
| 5010 | + <para> |
| 5011 | + Here is how you can convert an epoch value back to a time |
| 5012 | + stamp: |
| 5013 | + </para> |
| 5014 | + |
| 5015 | +<screen> |
| 5016 | +SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * interval '1 second'; |
5008 | 5017 | </screen> |
5009 | 5018 | </listitem> |
5010 | 5019 | </varlistentry> |
|