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/ |
`----------------------------------------------------------'
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 |