[SOLVED] date format

[felipeebs]

How to parse mysql dates (YYYY-MM-DD HH:II:SS) into a date("d/m/Y H:i:s") format?

 

<?php
//mysql_query and all stuff
date("d/m/Y H:i:s", $mysql_date_result); // This do not work for me
?>

[digitalgod]

you mean from a datetime field?

 

SELECT date_format( yourcolumn, '%c/%e/%Y %T' )
FROM table

[felipeebs]

is there any faster way to call the result, I mean:

$sql = "SELECT *, date_format(date, '%d/%m/%Y %T') FROM eyetest ORDER BY id DESC";

$query = mysql_query($sql);

while($n = mysql_fetch_assoc($query)){

	echo $n["id"].' | ';
	echo $n["date"].' | ';
	echo $n["date_format(date, '%d/%m/%Y %T')"].'<br />';

	print_r($n);
}

 

prints this:

2 | 2008-06-07 06:08:07 | 07/06/2008 06:08:07
1 | 2008-06-07 06:08:03 | 07/06/2008 06:08:03

 

I had to call $n["$n["date_format(date, '%d/%m/%Y %T')"]

Anything to simplify this?

 

Thanks

[T Horton]

Hi

 

Check this post I have just responded to. Sounds identical.

 

http://www.phpfreaks.com/forums/index.php/topic,200651.0.html

 

Any probs, shout.

 

Best Regards

 

 

 

Tom

[felipeebs]

That is it!

strtotime is just what I needed!

 

Thank you!

[solved]

[felipeebs]

I'm sorry for reviving this topic, but I found the query simpler way

with this

$results = mysql_fetch_assoc(mysql_query("SELECT date_format(date, '%M %d %Y %H:%i') as date FROM table"));
print_r($results);

will return

Array
(
    [date] => June 14 2008 14:08
)

 

conclusion:

SQL code "SELECT date_format(column, format)" can receive the keyword "as var", so it do not returns

$results[date_format(date, '%M %d %Y %H:%i')] = ...

but returns

$results[var] = ...

 

 

I'm sorry again, but this may be usefull for someone else.