Received: from inje.iskon.hr (root@inje.iskon.hr [213.191.128.16]) by hub.org (8.10.1/8.10.1) with ESMTP id e89Dvtf29666; Sat, 9 Sep 2000 09:57:55 -0400 (EDT) Received: from atlas.iskon.hr (atlas.iskon.hr [213.191.131.6]) by inje.iskon.hr (8.9.3/8.9.3/Debian 8.9.3-6) with ESMTP id PAA30390; Sat, 9 Sep 2000 15:57:53 +0200 Received: (from zcalusic@localhost) by atlas.iskon.hr (8.11.0/8.11.0/Debian 8.11.0-1) id e89CUZR00655; Sat, 9 Sep 2000 14:30:35 +0200 To: pgsql-sql@postgresql.org Cc: pgsql-general@postgresql.org Subject: Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) References: <874s3p3k1c.fsf@atlas.iskon.hr> Reply-To: zlatko@iskon.hr X-Face: s71Vs\G4I3mB$X2=P4h[aszUL\%"`1!YRYl[JGlC57kU-`kxADX}T/Bq)Q9.$fGh7lFNb.s i&L3xVb:q_Pr}>Eo(@kU, c:3:64cR]m@27>1tGl1):#(bs*Ip0c}N{:JGcgOXd9H'Nwm:}jLr\FZtZ pri/C@\,4lW<|jrq^<):Nk%Hp@G&F"r+n1@BoH From: Zlatko Calusic Date: 09 Sep 2000 14:30:35 +0200 In-Reply-To: Zlatko Calusic's message of "09 Sep 2000 13:02:39 +0200" Message-ID: <871yyt21ec.fsf@atlas.iskon.hr> Lines: 14 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.2 (Nike) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200009/220 Zlatko Calusic writes: > Is there any similar functionality (returning unixish number of > seconds since 1970 from the timestamp field) in PostgreSQL? It's amazing that I spent something like an hour trying to find an answer, and only ten minutes waiting for the answer to it. :) Mario Weilguni came up with a date_part('epoch', start) solution, and that is exactly what I was looking for. Thanks Mario! -- Zlatko