--- Tedit kap <[EMAIL PROTECTED]> wrote:

> I would like to modify the dae display format, for the dates stored in my
> database. 
> It is stored like this: 2008-07-01
> I want to print as: July, 1st
> Now I wrote something as below, but it displays Dec 31st instead of July 1st.
> (And in my database Dec31 is nowhere anyway). Please tell me how to fix.
> Here is the relevant part of code:
> while ($row = mysql_fetch_array($query)) {
> $c1=$row['date'];
> $c=date('F jS',$c1);
> echo"<p class='title1'>" . $c."<br/>". $row['title'] . "</p>" ; }
> Thanks


You obviously don't want to change the way the dates are stored in the database
but you might want to change the way they are displayed either with
command-line queries or in your PHP scripts.

You can use the date_format() function in MySQL to control the display of the
date/time in a MySQL query.  This can carry over to the value sent to your PHP
script.  It is often a good way to work with dates if you have them before 1970
(eg birthdates) or after 2030.  MySQL can handle dates from 1000-01-01 to
9999-12-31.  This range is much longer than the roughly 1970-2030 range
afforded to PHP and most computer operating systems.

You found the PHP function called date() and this is good.  However, it is
worth reading the documentation which identifies the second parameter to be a
number of seconds since the epoch date for that server (usually 1970-01-01
00:00:00).  The limited number of bits granted for this is why there's a
maximum value in 2030 or thereabouts.

You should not play games with slicing and dicing strings to get the values
out.  That might be necessary in some languages.  However, PHP has some more
powerful tools for working with this.  In this case, you could use strtotime()
to convert a date/time expression to the integer number of seconds since 1970
that date() wants to see:

$c1 = $row['date'];
$c  = date('F jS', strtotime($c1));
echo "<p class='title1'>" . $c."<br/>". $row['title'] . "</p>" ;

Remember the limits of the date range for the PHP expressions.  You may want to
use MySQL's date_format() function.

James

Reply via email to