Datetime in humane format
Richard Lynch <lynch@lscorp.com>
From: lynch@lscorp.com (Richard Lynch)
To: pgsql-sql@postgresql.org
Date: 1998-09-06T04:27:08Z
Lists: pgsql-sql
So, I followed the advice in the archives and used the datetime type. Now, I've got entries like 'Sun Sep 06 00:06:57 1998 EDT' in my table. So, how do I turn that into something that a normal human can read? "Sep 06 1998 12:06 am" would be nice... Or, how do I turn that back into seconds since epoch? I'm using PHP which has a nice date function that I think I can coerce into giving me what I want... unless it also thinks that humans understand 00:06:57 as just after midnight... -- -- -- "TANSTAAFL" Rich lynch@lscorp.com