Re: [GENERAL] conversion from epoch

2012-07-30 Thread Adrian Klaver
On 07/30/2012 07:36 AM, Little, Douglas wrote: I have an input source that is in epoch time.Is there a built-in conversion to changing to timestamp http://www.postgresql.org/docs/9.1/interactive/functions-formatting.html " to_timestamp(double precision) timestamp with time zone convert Unix

Re: [GENERAL] conversion from epoch

2012-07-30 Thread Steve Atkins
On Jul 30, 2012, at 7:36 AM, Little, Douglas wrote: > I have an input source that is in epoch time.Is there a built-in > conversion to changing to timestamp to_timestamp(). You can also do things like "select timestamptz 'epoch' + ? * interval '1 second'". Cheers, Steve -- Sent via

Re: [GENERAL] conversion from epoch

2012-07-30 Thread Andreas Kretschmer
"Little, Douglas" hat am 30. Juli 2012 um 16:36 geschrieben: > I have an input source that is in epoch time.Is there a built-in > conversion to changing to timestamp > > > select 'epoch'::date + * '1second'::interval; Andreas -- Sent via pgsql-general mailing list (pgsql-genera

[GENERAL] conversion from epoch

2012-07-30 Thread Little, Douglas
I have an input source that is in epoch time.Is there a built-in conversion to changing to timestamp Thanks Doug Little Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide 500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.516