Re: [SQL] converting epoch to timestamp

2005-10-27 Thread Rajesh Kumar Mallah
On 10/26/05, Richard Huxton wrote: > Rajesh Kumar Mallah wrote: > > Hi, > > > > Can anyone tell me how to convert epoch to timestamp ? > > > > ie reverse of : > > > > SELECT EXTRACT( epoch FROM now() ); > > I'd start with either Google or the manuals. > > http://www.postgresql.org/docs/8.0/intera

Re: [SQL] converting epoch to timestamp

2005-10-26 Thread Stef
Rajesh Kumar Mallah mentioned : => Can anyone tell me how to convert epoch to timestamp ? => => ie reverse of : => => SELECT EXTRACT( epoch FROM now() ); => +--+ => |date_part | => +--+ => | 1130317518.61997 | => +--+ Here is one way (In m

Re: [SQL] converting epoch to timestamp

2005-10-26 Thread A. Kretschmer
am 26.10.2005, um 14:35:51 +0530 mailte Rajesh Kumar Mallah folgendes: > Hi, > > Can anyone tell me how to convert epoch to timestamp ? > > ie reverse of : > > SELECT EXTRACT( epoch FROM now() ); > +--+ > |date_part | > +--+ > | 1130317518.61997 | > +---

Re: [SQL] converting epoch to timestamp

2005-10-26 Thread Richard Huxton
Rajesh Kumar Mallah wrote: Hi, Can anyone tell me how to convert epoch to timestamp ? ie reverse of : SELECT EXTRACT( epoch FROM now() ); I'd start with either Google or the manuals. http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html Scroll down to the section on "epoc

[SQL] converting epoch to timestamp

2005-10-26 Thread Rajesh Kumar Mallah
Hi, Can anyone tell me how to convert epoch to timestamp ? ie reverse of : SELECT EXTRACT( epoch FROM now() ); +--+ |date_part | +--+ | 1130317518.61997 | +--+ (1 row) Regds mallah. ---(end of broadcast)--

Re: [SQL] Converting epoch to timestamp?

2001-08-01 Thread Josh Berkus
Tom, > regression=# select timestamp(996673954); >timestamp > > 2001-08-01 09:52:34-04 > (1 row) > > (This last didn't use to work, but it seems fine in 7.0 and 7.1. It > will fail in 2038 when timestamps stop looking like int4, but by then > hopefully we'll ha

Re: [SQL] Converting epoch to timestamp?

2001-08-01 Thread Tom Lane
"Richard Huxton" <[EMAIL PROTECTED]> writes: >> I searched the docs for function to convert epoch to timestamps but >> couldn't find any. Are there any? > richardh=> select '1970-01-01'::date + '996654342 seconds'::interval; > ?column? > > 2001-08-01 08:25:42+01

Re: [SQL] Converting epoch to timestamp?

2001-08-01 Thread Roberto Mello
On Wed, Aug 01, 2001 at 09:28:39AM +0100, Richard Huxton wrote: > Hi Roberto - long time no see. Hey Richard. Yeah. Summer classes and summer jobs :-) I have to finish my expanded "Porting From Oracle" thingy. > > richardh=> select '1970-01-01'::date + '996654342 seconds'::interval; >

Re: [SQL] Converting epoch to timestamp?

2001-08-01 Thread Richard Huxton
From: "Roberto Mello" <[EMAIL PROTECTED]> Hi Roberto - long time no see. > I searched the docs for function to convert epoch to timestamps but > couldn't find any. Are there any? richardh=> select now(); now 2001-08-01 09:25:58+01 (1 row) richardh=> select e

[SQL] Converting epoch to timestamp?

2001-07-31 Thread Roberto Mello
I searched the docs for function to convert epoch to timestamps but couldn't find any. Are there any? Thanks, -Roberto -- +| Roberto Mello - http://www.brasileiro.net |+ Computer Science, Utah State University - http://www.usu.edu USU