Re: Date calc/comparisions

You could do

SELECT EXTRACT(EPOCH FROM <timestamp>);

-- To get epoch, then use PHP to do the date calculation.. You could do the
calculation in the database too, though..

Check out
http://postgresql.crimelabs.net/users-lounge/docs/7.1/user/functions-datetim
e.html

----- Original Message -----
From: "Brent R. Matzelle" <bmatzelle(at)yahoo(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Wednesday, September 05, 2001 1:24 PM
Subject: [PHP] Date calc/comparisions

> I need to know if the date returned from a TIMESTAMP field is less than 24
hours old.
> However, PHP does not understand how to compare times retrieved from
PostgreSQL.
> Have any of you any experience with this type of calculation?
>
> Thanks and warm regards,
>
> Brent
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>