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@xxxxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> Sent: Thursday, September 06, 2001 11:14 AM Subject: Re: [PHP] Date calc/comparisions > --- 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx >
