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@xxxxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> 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 >
