Skip site navigation (1) Skip section navigation (2)

Re: Date calc/comparisions

From: "Mitch Vincent" <mvincent(at)cablespeed(dot)com>
To: <pgsql-php(at)postgresql(dot)org>, "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>
Subject: Re: Date calc/comparisions
Date: 2001-09-06 04:01:50
Message-ID: 003d01c13688$be7c8bd0$f8165dd8@mitch (view raw or flat)
Thread:
Lists: pgsql-php
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
>


In response to

Responses

pgsql-php by date

Next:From: Brent R. MatzelleDate: 2001-09-06 15:14:22
Subject: Re: Date calc/comparisions
Previous:From: Brent R. MatzelleDate: 2001-09-05 17:24:47
Subject: Date calc/comparisions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group