[EMAIL PROTECTED] writes:
> 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
> 1, 1970).
regression=# select date_part('epoch','2001-02-05 17:23:26.123456-08'::timestamp);
date_part
--
On Tue, 6 Feb 2001 [EMAIL PROTECTED] 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 0
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_t
