ot;Pavel Jartsev" <[EMAIL PROTECTED]>
To: "Matthew Ralston" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 6:21 AM
Subject: Re: [PHP] Converting MySQL Date (2001-05-21) to Friendly Date (21
May 2001)
> Matthew Ralston wrote:
> >
> &g
Thanks Papi,
That works fine.
Matt
[EMAIL PROTECTED]
< www.mralston.co.uk />
Pavel Jartsev <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Matthew Ralston wrote:
> >
> > I've got a date stored in a MySQL database in a "DATE" field, so it is
> > stored as "200
Matthew Ralston wrote:
>
> I've got a date stored in a MySQL database in a "DATE" field, so it is
> stored as "2001-05-21". How do I convert that into a more friendly date like
> "21 May 2001" or even "21st May 2001" for display on a web page?
>
> I've tried
>
> print date("jS F Y", $dbtable[da
Mathew,
Great that they're backwards from one another, isn't it?
The regular expression wizards probably have some marvellous trick up their
sleeve, and Manuel Lemos probably has a class that will do this. You can do
it yourself by using substring functions to extract the parts of the date,
r
You could consider using DATE_FORMAT() when pulling the date out of the
MySQL Table.
HAve a look in the mysql manpages for the ezxact syntax
Wieger
Matthew Ralston wrote:
>
> I've got a date stored in a MySQL database in a "DATE" field, so it is
> stored as "2001-05-21". How do I convert tha
I've got a date stored in a MySQL database in a "DATE" field, so it is
stored as "2001-05-21". How do I convert that into a more friendly date like
"21 May 2001" or even "21st May 2001" for display on a web page?
I've tried
print date("jS F Y", $dbtable[date]);
but I always get "1st January 197
6 matches
Mail list logo
