| 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()?) |