Date convert from SQL

[eluser]PhilTem[/eluser]
There's no native PHP mdate function but it's a CI helper function. So you should ensure, that you loaded the date-helper prior to calling the method.

Secondly, I think you're not using the write markup. From the user's guide

Code:

$datestring = "Year: %Y Month: %m Day: %d - %h:%i %a";
$time = time();

echo mdate($datestring, $time);

In this case, $time is something like 123456789. And that's not matching your format