Re: reverse of extract epoch?

Поиск
Список
Период
Сортировка
От Gregory Seidman
Тема Re: reverse of extract epoch?
Дата
Msg-id 20020603183205.GA14198@jamaica.cs.brown.edu
обсуждение исходный текст
Ответ на Re: reverse of extract epoch?  (Neil Conway <nconway@klamath.dyndns.org>)
Список pgsql-general
Neil Conway sez:
} On Sun, 2 Jun 2002 21:17:50 -0400
} "Gregory Seidman" <gss+pg@cs.brown.edu> wrote:
} > Now I want to create its reverse so I can get a timestamp (with tz) from an
} > epoch-based integer. Is there some simple way of doing it?
}
} Try:
}
} select "timestamp"(extract(epoch from now())::int);

Yowza! It's been there all along! I actually wanted timestamptz(), as it
turns out, but I found that easily. Thank you!

} Cheers,
}
} Neil
--Greg


В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew Perrin
Дата:
Сообщение: Re: [ADMIN] performance issues with DBI module when data too big
Следующее
От: "Johnson, Shaunn"
Дата:
Сообщение: invalid type error