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

Поиск
Список
Период
Сортировка
От Zlatko Calusic
Тема Re: [GENERAL] Porting from mysql to psql (UNIX_TIMESTAMP()?)
Дата
Msg-id 871yyt21ec.fsf@atlas.iskon.hr
обсуждение исходный текст
Ответ на Porting from mysql to psql (UNIX_TIMESTAMP()?)  (Zlatko Calusic <zlatko@iskon.hr>)
Список 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 по дате отправления:

Предыдущее
От: Zlatko Calusic
Дата:
Сообщение: Porting from mysql to psql (UNIX_TIMESTAMP()?)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Porting from mysql to psql (UNIX_TIMESTAMP()?)