PostgreSQL date type as bigint in Postmodern
Rel
stler at gmx.de
Sat Jul 18 13:59:32 UTC 2015
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!
More information about the postmodern-devel
mailing list