Re: How to format a date?

On 14 Jan, 23:59, Martin <martinval...@xxxxxxxxxxx> wrote:
On Mon, 14 Jan 2008 23:34:38 -0000, "Paul Lautman"



<paul.laut...@xxxxxxxxxxxxxx> 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.
.