[SQL] Re: [GENERAL] Porting from mysql to psql (UNIX_TIMESTAMP()?)

[Zlatko Calusic]

Zlatko Calusic <[EMAIL PROTECTED]> 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