From 7306b84d7f890afe342d2850d7f9e994f01c3181 Mon Sep 17 00:00:00 2001 From: Mark Huang Date: Tue, 16 Jan 2007 17:03:01 +0000 Subject: [PATCH] - cast verification_expires to int --- planetlab4.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/planetlab4.sql b/planetlab4.sql index 22599862..55f05f0f 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, -- 2.47.0