Unix dateformat ?

From: Zsolt Varga <redax(at)agria(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Unix dateformat ?
Date: 1998-12-15 08:23:55
Message-ID: Pine.LNX.3.96.981215090617.2087A-100000@lupus.agria.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hi!

correct me, but is this possible postgresql doesn't contains any function
to convert date/datetime format to unix timestamp format?

in mysql I can do it with:

mysql> select unix_timestamp( now() ) as stamp;
+-----------+
| stamp |
+-----------+
| 913710262 |
+-----------+

before I make any function in 'c', please if you know some solution inform
me,

thanks,
regards
Redax

.----------------------------------------------------------.
|Zsolt Varga | tel/fax: +36 36 422811 |
| AgriaComputer LTD | email: redax(at)agria(dot)hu |
| System Administrator | URL: http://www.agria.hu/ |
`----------------------------------------------------------'

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Zsolt Varga 1998-12-15 08:49:00 Mea Culpa (was: Unix dateformat ?)
Previous Message Postgres DBA 1998-12-15 08:02:54 CREATE RULE question