Martin wrote:
Quote:
On Mon, 14 Jan 2008 23:34:38 -0000, "Paul Lautman"
<paul.lautman@btinternet.comwrote:
>
Quote:
>Martin wrote:
Quote:
>>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 at
www.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".
>
>
>
>
Well, the fact that many users come here without even having opened the man'
might be bothering, you should consider that. Of course I agree that we're
also here to redirect people to what they need if the request is something
widely assumed as 'basic'; many people would just say "Google that!" whereas
the personal glossary of the OP simply needs one or two little more entries.
In your case, I guess you aren't actually searching for date formatting, but
string formatting.
http://php.net/manual/en/ref.strings.php
You obviously don't need more than these native functions to do what you
want to. If your time is really running out, I suggest you start playing
with substr().
If you feel like you need further reading, you might be interested in
Regular Expressions.
http://www.regular-expressions.info/ http://php.net/manual/en/ref.pcre.php
Despite all of that, you can also convert your date to a UNIX timestamp,
using string functions as well as mktime(), or, as Paul pointed out, with
strtotime() if you're confident with the source format. You'll then have no
problem to re-format the timestamp with date().
You could have put a hand on these functions by reading a little further the
function references of "Date and Time" you should have found by following
Paul's "directives". Yep, I felt lucky, and he was right.
http://php.net/manual/en/ref.datetime.php
"Google" vs "Direct-Help" is an everlasting debate.
No kittens are ate anyway, so keep your cool.
-thibī
