Re: timestamp- milliseconds since epoch output - Mailing list pgsql-sql

From Karel Zak
Subject Re: timestamp- milliseconds since epoch output
Date
Msg-id Pine.LNX.3.96.1010206194654.3799G-100000@ara.zf.jcu.cz
Whole thread Raw
In response to timestamp- milliseconds since epoch output  (jkakar@expressus.com)
List 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 by date:

Previous
From: Karel Zak
Date:
Subject: Re: type casting: varchar to date
Next
From: Brice Ruth
Date:
Subject: Re: SQL Join - MySQL/PostgreSQL difference?