Re: Date confusion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Jul 28, 2005, at 9:28 AM, Linda H wrote:

Hi,

I must admit I am surprised at the paucity of date and time functions in PHP.

I have a date stored in a MySQL database in field of datatype date. PHP doesn't seem to have a function I can use to format it for print. I tried the following but regardless of the value in the date field, it displays as 'Wednesday December 31, 1969' (I know this is the day before the UNIX epoch.).

echo '<p>'.date('l F j, Y',$start_date).'</p>';

I tried casting the field to datetime, but it didn't pass the parser. Finally I did the following, which seems to work, but is awfully convoluted:

echo '<p>Date: '.date('l F j, Y',strtotime($start_date).'</p>';

The other thing I'm concerned about is that strtotime takes the locale into consideration. I don't want it adjusting the date - I just want it printed out.

Is there a better way to do this?

SELECT DATE_FORMAT(myfield, '%W %M %e, %Y') as 'formatted_date' FROM ....

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux