Joomla Real Estate

I tried to do date_format in the function requests...but doesn´t work !!


$database->setQuery("SELECT *, DATE_FORMAT(rent_from , '%d/%m/%Y' FROM #__rem_houses AS a" .
" nLEFT JOIN #__rem_rent_request AS l" .
" nON l.fk_houseid = a.id" .
" nWHERE l.status = 0" .
" nORDER BY l.id DESC" .
" nLIMIT $pageNav->limitstart,$pageNav->limit;" ;
$rent_requests = $database->loadObjectList();
echo $database->getErrorMsg();
$total = $database->loadResult();


I NEED ANY HELP FOR THIS....!!!!!

Thanks
Beto

Dear Beto,

I am show to you PHP function. You need use it in PHP(not in MySQL) !!!
Please check our code, how we use it

If you need convert date at time receive it from MySQL, Please check mysql functions
dev.mysql.com/doc/refman/5.7/en/date-and...#function_get-format

Regards
Andrew
OrdaSoft team

Hi,

but this link refers to MySQL code ??!!

I don´t understand

Beto

I´ve tried everything I can
NOTHING WORKS
Beto

Hi,



This is php code, data_transform_rem - PHP function,
$review->date - this data from database.

Regards
Andrew