Posted by Captain Paralytic on 10/14/58 12:00

On 14 Jan, 23:59, Martin <martinval...@comcast.net> wrote:
> On Mon, 14 Jan 2008 23:34:38 -0000, "Paul Lautman"
>
>
>
> <paul.laut...@btinternet.com> wrote:
> >Martin wrote:
> >> I'm retrieving some records from a database. One of the fields
> >> contains a date/time. I would like to format it as I send it out to
> >> the table in the displayed page.
>
> >> Can some one please tell me how I can/should do that? Or possibly
> >> point me to an on-line explanation?
>
> >> Thanks
>
> >> ps: if it makes any difference, the data is coming from a MS Access
> >> MDB file which I'm reading in via ODBC.
>
> >It is a 6 step process:
>
> >Step 1) Point your browser atwww.google.com
> >Step 2) In the search box type: php date formatting
> >Step 3) Click the button labelled "I'm Feeling Lucky"
> >Step 4) Read the manual page that you are presented with
> >Step 5) Think "Why did I bother posting this question to usenet when I could
> >have found the answer in an instant by doing steps 1-4"
> >Step 6) Vow to do the obvious and try to help myself in the fuure.
>
> Thanks for the wise-ass answer Paul.
>
> The fact of the matter is, I already spent an hour or so Googling and
> experimenting with various things. In fact, I tried using the exact
> page that you so politely pointed out. But I quickly found out that
> that page actually explains how to format the system date value. As
> I'm sure you'll notice, if you would bother to read my question, I'm
> trying to format a date/time string that I'm retrieving from a
> database.
>
> I suggest that you re-word your step 5 to: Think "Why did I bother
> posting this question to a usenet group where I get smart-ass answers
> that don't do any good".

I suggest you practice reading. The date function takes a second
optional argument of a date value. I quote from the very top of teh
page:
"Returns a string formatted according to the given format string using
the given integer timestamp or the current time if no timestamp is
given. In other words, timestamp is optional and defaults to the value
of time()."

So you quickly didn't find out what the page said, because you didn't
even bother to read it properly.

[Back to original message]