Re: [SQL] Datetime in humane format

At 6:27 +0200 on 6/9/98, Richard Lynch wrote:

> 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...

That depends on the country... To me, 24-hour clocks are as natural as
hailing a cab.

Seconds since epoch - very easy: the function date_part will do that for
you. Read the manpage of pgbuiltin.

Perhaps its worthwhile to delve into the PHP documentation. Perhaps you can
transfer the result you got from a query on a date field directly to some
PHP date type which allows formatting. At least in Java that's how it's
done - so why not in others.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma