Datetime in humane format

From: lynch(at)lscorp(dot)com (Richard Lynch)
To: pgsql-sql(at)postgresql(dot)org
Subject: Datetime in humane format
Date: 1998-09-06 04:27:08
Message-ID: v02140b15b2177863c44f@[207.152.64.133]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)lscorp(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1998-09-06 11:16:32 Re: [SQL] Datetime in humane format
Previous Message Andrew M Tracey 1998-09-05 18:23:31 constraints don't work...