Re: timestamp- milliseconds since epoch output

Поиск
Список
Период
Сортировка
От Karel Zak
Тема Re: timestamp- milliseconds since epoch output
Дата
Msg-id Pine.LNX.3.96.1010206194654.3799G-100000@ara.zf.jcu.cz
обсуждение исходный текст
Ответ на timestamp- milliseconds since epoch output  (jkakar@expressus.com)
Список pgsql-sql
On Tue, 6 Feb 2001 jkakar@expressus.com wrote:

> Hi,
> 
> I'm using a timestamp field called date_created.  Whenever I select it
> I get:
> 
> select date_created from tbl_user;
>       date_created      
> ------------------------
>  2001-02-05 17:23:26-08
>  2001-02-05 17:45:39-08
>  2001-02-03 03:58:53-08
> (3 rows)
> 
> I've tried using variations of to_char and to_timestamp but can't seem
> to get the timestamp as a value of milliseconds since the Epoch (Jan
to_char() and to_timestamp() are milliseconds ignorant routines. It's in 
my TODO list for next release -- now we in feature freeze state. 
        Karel



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

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: type casting: varchar to date
Следующее
От: Brice Ruth
Дата:
Сообщение: Re: SQL Join - MySQL/PostgreSQL difference?