PROTECTED]
Sent: Tuesday, May 18, 2004 8:22 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Date Format in MySQL
DISCLAIMER: By sending any electronically information to Mr. B.A.T.
Svensson' mailbox the sender agrees that, regardless content,
attachments, intended recipient, disclaimers,
DISCLAIMER: By sending any electronically information to Mr. B.A.T.
Svensson' mailbox the sender agrees that, regardless content,
attachments, intended recipient, disclaimers, human error, stupidity,
plain ignorance or any other legal claims or matter, that B.A.T.
Svensson is to be consider the exc
Slightly off php topic
I would like to know if I can change the default date format on MySQL server
either for the entire server or for a particular database, as apposed to
formatting the date every time I input data or retrieve it out the database.
Thanks
Steven
~ Techtron Computers & Electro
he
month out and pick any day and year. This will work fine unless you're
trying to get "day of the week".
-TG
> -Original Message-
> From: Sudeep Zamudra [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 13, 2004 4:48 AM
> To: [EMAIL PROTECTED]
> Subject:
Hi everyone,
I want to convert a date 1965-12-25 into the format: 25-Dec-1965.
When i use mktime it works fine for any date after the year 1970. It doesn't work for
any date before 1970. Help please. Is there any function that shows the date in the
above required format.
or if you want to us 12hour clock try this:
$todaydatetime = date("Y m d g:i");
That will translate into:
2002 11 07 6:12
[snip]
It is ok, but is there some way i do $mydate=format_date($date,Y m d
:i") - is there some function that could do it, where $date is some date,
not neccessarily tod
l Message-
From: Adrian Partenie [mailto:adrian.partenie@;artelecom.net]
Sent: 07 November 2002 16:06
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] date format, php, mysql
Hello,
How can I modify a date format from $b="Jan 7 1999, 3:51 pm" into other
format? like
1999 01 07 3:51 for example?
look at the function called strtotime()
uk.php.net/strtotime
it will convert English language date into timestamp, from which you can
do date() again to reformat it
--
Maxim Maletsky
[EMAIL PROTECTED]
"Adrian Partenie" <[EMAIL PROTECTED]> wrote... :
> Hello,
>
> How can I modify a date fo
Hello,
How can I modify a date format from $b="Jan 7 1999, 3:51 pm" into other format? like
1999 01 07 3:51 for example? I have tried with strftime, but it change format only for
current date.
Thanks, Adrian
