--- Mitch Vincent <mvincent@xxxxxxxxxxxxxx> 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
