Hello,
regarding the type date from PostgreSQL, when I query th DB with Postmodern like (query "select * from es"), a bigint is returned for date-columns (e.g. 3586982400 for "2013-09-01"). I assumed that this is a unix timestamp, but when I convert 3586982400 with a tool back to a normal date format it says "09/01/2083 @ 12:00am (UTC)". Can somebody bring some light to this?
Thank you!
Hello,
What you are getting is a Common Lisp universal-time, not a Unix timestamp.
Best, Marijn
On Sat, Jul 18, 2015 at 3:59 PM, Rel stler@gmx.de wrote:
Hello,
regarding the type date from PostgreSQL, when I query th DB with Postmodern like (query "select * from es"), a bigint is returned for date-columns (e.g. 3586982400 for "2013-09-01"). I assumed that this is a unix timestamp, but when I convert 3586982400 with a tool back to a normal date format it says "09/01/2083 @ 12:00am (UTC)". Can somebody bring some light to this?
Thank you!
postmodern-devel@common-lisp.net
-
Marijn Haverbeke -
Rel