OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Date format dd/mm/yy (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

Date format dd/mm/yy

alfabeto (Visitor)
Posts: 0
graphgraph
User Offline
Re:Date format dd/mm/yy 7 Years, 5 Months ago
Karma: 0  
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
Logged Logged
Last Edit: 2017/06/04 12:26 By .
The administrator has disabled public write access.
alfabeto (Visitor)
Posts: 0
graphgraph
User Offline
Re:Date format dd/mm/yy 7 Years, 5 Months ago
Karma: 0  
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8366
graph
User Offline Click here to see the profile of this user
Re:Date format dd/mm/yy 7 Years, 5 Months ago
Karma: 102  
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
Logged Logged
The administrator has disabled public write access.
alfabeto (Visitor)
Posts: 0
graphgraph
User Offline
Re:Date format dd/mm/yy 7 Years, 5 Months ago
Karma: 0  
Hi,

but this link refers to MySQL code ??!!

I don´t understand

Beto
Logged Logged
The administrator has disabled public write access.
alfabeto (Visitor)
Posts: 0
graphgraph
User Offline
Re:Date format dd/mm/yy 7 Years, 5 Months ago
Karma: 0  
I´ve tried everything I can
NOTHING WORKS
Beto
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8366
graph
User Offline Click here to see the profile of this user
Re:Date format dd/mm/yy 7 Years, 5 Months ago
Karma: 102  
Hi,

Code:

echo data_transform_rem($review->date);


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

Regards
Andrew
Logged Logged
The administrator has disabled public write access.
Go to top
»