Problems with my date format

[jeddi]

Hi,

Today is 11th December 2012

I have my date stored in my MySql dbase as a datetime
in this format: 2012-12-11 00:00:00

I want to output it as m/d/y format.

So I would like: 12/11/12


I have tried this:

PHP Code:

$N_pub_date     = "{$row['pub_date']}";
$N_pub_date = date("m/d/y", $N_pub_date); 

echo $N_pub_date 


But I am getting this: 12/31/69

Anyone know how I correct this problem ?

Thanks


.

[idalatob]

The problem is, the date function expects a timestamp as the second parameter and not a mysql date.

Try this:

PHP Code:

$N_pub_date     = strtotime("{$row['pub_date']}"); 
$N_pub_date = date("m/d/y", $N_pub_date);  

echo $N_pub_date 


[abduraooft]

I have my date stored in my MySql dbase as a datetime
in this format: 2012-12-11 00:00:00

I want to output it as m/d/y format.

So I would like: 12/11/12

It'd better to use the function date_format() in mysql itself.

[jeddi]

Hi,

Thanks for replies.

I tried:

PHP Code:

$N_pub_date     = strtotime("{$row['pub_date']}"); 
$N_pub_date     = date("m/d/y", $N_pub_date); 


But I still get: 12/31/69

I looked at the MYSQL link and think I need this:

PHP Code:

SELECT DATE_FORMAT('2009-10-04 22:23:00', '%m/%d/%Y'); 


But how do write that into my php code ?

Thanks

[Fou-Lu]

I would suspect you have a cached page there. If pub_date is 2009-10-04 22:23:00, that is valid.
The DATE_FORMAT is used in SQL, not in PHP. Simply modify the query and add the DATE_FORMAT(pub_date, '%m/%d/%Y') AS formattedDate, then pull the formattedDate from the resultset.

[jeddi]

So my query is :

PHP Code:

$sql = "SELECT * FROM pages WHERE page_id = $Db_page_id AND client_no = '$this_client' "; 


So if I want to include

DATE_FORMAT(pub_date, '%m/%d/%Y') AS formattedDate

then I'll have to list all the records I guess ??
( there are about 18 of them )

It seems to me it would be nicer to just reformat the result for that record.

Something like :

PHP Code:

$N_pub_date     = strtotime("{$row['pub_date']}"); 
$N_pub_date     = date("m/d/y", $N_pub_date); 


Can it not be done with php ??

Thanks.


.

[Fou-Lu]

This is fine:

PHP Code:

$N_pub_date     = strtotime("{$row['pub_date']}"); 
$N_pub_date     = date("m/d/y", $N_pub_date); 


So long as $row['pub_date'] represents a valid datetime string in SQL and strtotime is available (which it has been since like, 4.2 or something like that). So if I do this:

PHP Code:

$row = array('pub_date' => '2009-10-04 22:23:00');
$N_pub_date     = strtotime("{$row['pub_date']}"); 
$N_pub_date     = date("m/d/y", $N_pub_date);
printf('Date: %s', $N_pub_date); 


I get this:

Date: 10/04/09

As for SQL, although I'd suggest querying for each property separately, you can mix and match wildcards with explicits. SELECT *, DATE_FORMAT(pub_date, '%m/%d/%Y') AS formattedDate FROM. . . is fine.

[jeddi]

Thanks

I have it working now