PostgreSQL Timestamp zu Unix Timestamp

Wednesday, 18 February 2009

So kann man aus einem PostgreSQL Timestamp einen Unix Timestamp machen:

select  extract(epoch from "timestamp"(postgres_timestamp)) as unix_timestamp from table

Tags: ,

The entry 'PostgreSQL Timestamp zu Unix Timestamp' was posted on February 18th, 2009 at 11:56 and last modified on June 26th, 2010 at 22:09, and is filed under Allgemein. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.

«
»