Re: timestamp- milliseconds since epoch output

On Tue, 6 Feb 2001 jkakar(at)expressus(dot)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