[Resolved] converting date

Hi there.. as i m noob in php i ve found a function in the database section and used it...

i used the NOW() function. so i got this:

104128/210104/2005

10:41:28 i think is the time
2005 year

but.. wth is 210104? 😕

And how can i convert it to something like:

28/02/2005 10:41

Thanx for any help 🙂

Edit:

Omg i need to sleep.. i forgot that i was using a function to display the data:

$day = substr($date ,8,10);
$m = substr($date,5,-3);
$yr = substr($date ,0,4);
$date = $day."/".$m."/".$yr;

is there another way to convert it? and how does the substr() function works?

Thanx😕

Take a look at the mktime() function to convert the date to a unix timestamp. Then format it with the date() function.

echo date("j/m/Y G:i", mktime(10,41,0,02,28,2005) );

This will give you what you were looking for.
And check out the documentation on the date() function.

Thanx for helping..

this thread solved my problem 🙂

I just need to show the data like this 30/12/2005 😃