On 17-May-01 Jack Sasportas wrote:
> OK I have asked the question before and not really gotten the answer, so
> I will re-word what I am trying to do.
> First I figured out that part of my problem may be how I am storing the
> date into mysql from php.
> Currently we are using the now() function to store the date in one field
> and the time in another. I know understand what is physically being
> stored in the db.
>
> I am trying to retreive the date value from the mysql db, and display it
> on the screen in a standard format like 05/08/01.
> What I get right now is 2001-05-09.
> Also the time comes out like so: 227:08:22
>
> I have tried this:
> $t_data_array[1]=date("m/d/y",mysql_result($db_result,$db_record,'date'));
>
> and the result is: 12/31/69 formatted nicely but that date is 5/9/2001
> not 1969.
>
> I have tried several suggestions and other things, but I am not being
> successful.
>
>
> Here is what I am trying to do:
> I would like the result of the date to be formatted as 05/01/01
> and the time as 18:51
>
> Please give me some very specific instructions, this is a silly thing to
> be stuck on...
>
> $t_data_array[1]=mysql_result($db_result,$db_record,'date');
> $t_data_array[2]=mysql_result($db_result,$db_record,'time');
>
A. Have MySQL do the formatting:
select DATE_FORMAT('%m/%d/%y %r', mydate) as da_date from ...
B. parse it and let PHP do the heavy lifting:
list ($y, $m, $d, $h, $i, $s)=explode('- :', $row->mydate);
$da_date=strftime('%D %r', mktime($h, $i, $s, $m, $d, $y);
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
