Commit4b1a35b

committed

Add example for converting epoch back to timestamp.

1 parent0fb3ec1 commit4b1a35bCopy full SHA for 4b1a35b

File tree

+10

-1

lines changed

+10

-1

lines changed

Lines changed: 10 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`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>`

Comments

(0)