Re: [GENERAL] Porting from mysql to psql (UNIX_TIMESTAMP()?) - Mailing list pgsql-sql

From Zlatko Calusic
Subject Re: [GENERAL] Porting from mysql to psql (UNIX_TIMESTAMP()?)
Date
Msg-id 871yyt21ec.fsf@atlas.iskon.hr
Whole thread Raw
In response to Porting from mysql to psql (UNIX_TIMESTAMP()?)  (Zlatko Calusic <zlatko@iskon.hr>)
List pgsql-sql
Zlatko Calusic <zlatko@iskon.hr> writes:

> Is there any similar functionality (returning unixish number of
> seconds since 1970 from the timestamp field) in PostgreSQL?

It's amazing that I spent something like an hour trying to find an
answer, and only ten minutes waiting for the answer to it. :)

Mario Weilguni came up with a date_part('epoch', start) solution, and
that is exactly what I was looking for.

Thanks Mario!
--
Zlatko

pgsql-sql by date:

Previous
From: Zlatko Calusic
Date:
Subject: Porting from mysql to psql (UNIX_TIMESTAMP()?)
Next
From: Tom Lane
Date:
Subject: Re: Porting from mysql to psql (UNIX_TIMESTAMP()?)