From: | Zlatko Calusic <zlatko(at)iskon(dot)hr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) |
Date: | 2000-09-09 12:30:35 |
Message-ID: | 871yyt21ec.fsf@atlas.iskon.hr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Zlatko Calusic <zlatko(at)iskon(dot)hr> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Richter | 2000-09-09 14:18:03 | Search inherited tables |
Previous Message | Enrico Comini | 2000-09-09 11:55:34 | OT-Jscript |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-09-09 16:59:47 | Re: [SQL] Porting from mysql to psql (UNIX_TIMESTAMP()?) |
Previous Message | Rommel B. Abaya | 2000-09-09 11:25:59 | Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) |