Re: Date calc/comparisions - Mailing list pgsql-php

--- 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