Thread: Date calc/comparisions

Date calc/comparisions

From
"Brent R. Matzelle"
Date:
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



Re: Date calc/comparisions

From
"Mitch Vincent"
Date:
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@yahoo.com>
To: <pgsql-php@postgresql.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
>


Re: Date calc/comparisions

From
"Brent R. Matzelle"
Date:
--- Mitch Vincent <mvincent@cablespeed.com> wrote:
> 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

Thanks for the response.  Actually I found a slightly better way
of accomplishing the same thing last night.  I can change the
PostgreSQL TIMESTAMP to a PHP viable Unix timestamp by
eliminating the time zone stuff from the end of the string:

$timestamp = "2001-09-05 21:12:45-04" // simulate a PG timestamp

// Eliminates the "-04"
$timestamp = substr($timestamp, 0, -3);

$unix_time = strtotime($timestamp);

// Now I can convert it:
$pretty_time = date("Y M d H:i", $unix_time);

Regards,

Brent

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

Re: Date calc/comparisions

From
"Mitch Vincent"
Date:
I generally do all my date calculations in PG, it's set of functions for
time spans and such are most excellent..

Good luck!

-Mitch

----- Original Message -----
From: "Brent R. Matzelle" <bmatzelle@yahoo.com>
To: <pgsql-php@postgresql.org>
Sent: Thursday, September 06, 2001 11:14 AM
Subject: Re: [PHP] Date calc/comparisions


> --- Mitch Vincent <mvincent@cablespeed.com> wrote:
> > 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
>
> Thanks for the response.  Actually I found a slightly better way
> of accomplishing the same thing last night.  I can change the
> PostgreSQL TIMESTAMP to a PHP viable Unix timestamp by
> eliminating the time zone stuff from the end of the string:
>
> $timestamp = "2001-09-05 21:12:45-04" // simulate a PG timestamp
>
> // Eliminates the "-04"
> $timestamp = substr($timestamp, 0, -3);
>
> $unix_time = strtotime($timestamp);
>
> // Now I can convert it:
> $pretty_time = date("Y M d H:i", $unix_time);
>
> Regards,
>
> Brent
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>