X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=planetlab4.sql;h=55f05f0f425d9e8f0ef86d4b6ea2d521a8a41612;hb=6c38f39a5bd62c83ed181f1fe1e47f67446e7dec;hp=22599862f8d68bf9a6f89f9376397ab3f5ebc37e;hpb=b29b1c5226b1bf70bfb69911100794a34f68983a;p=plcapi.git diff --git a/planetlab4.sql b/planetlab4.sql index 2259986..55f05f0 100644 --- a/planetlab4.sql +++ b/planetlab4.sql @@ -9,7 +9,7 @@ -- -- Copyright (C) 2006 The Trustees of Princeton University -- --- $Id: planetlab4.sql,v 1.60 2007/01/09 16:23:47 mlhuang Exp $ +-- $Id: planetlab4.sql,v 1.61 2007/01/11 05:26:34 mlhuang Exp $ -- -------------------------------------------------------------------------------- @@ -801,7 +801,7 @@ persons.deleted, persons.enabled, persons.password, persons.verification_key, -persons.verification_expires, +CAST(date_part('epoch', persons.verification_expires) AS bigint) AS verification_expires, persons.title, persons.phone, persons.url,