Received: from lscorp.com (poohbah.lscorp.com [207.152.64.2]) by hub.org (8.8.8/8.7.5) with ESMTP id AAA12220 for ; Sun, 6 Sep 1998 00:29:19 -0400 (EDT) Received: from [207.152.64.133] by lscorp.com with SMTP (Eudora Internet Mail Server 1.2); Sat, 5 Sep 1998 23:27:08 -0500 X-Sender: lynch@poohbah.lscorp.com Message-Id: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: pgsql-sql@postgresql.org From: lynch@lscorp.com (Richard Lynch) Subject: Datetime in humane format Date: Sat, 5 Sep 1998 23:27:08 -0500 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