5
timgno:
I think the line in mysearch module is hardcoded and didnt use the xoops local functions.
$criteria->add(new Criteria("date_format(datesearch,'%X-%m-%d')", $date,'<='));
Xoops has a function for all output date/time called "formatTimestamp"
The main function is located at class/xoopslocal.php but local parties can define their own function in language/LOCAL_LANGUAGE/locale.php
in "formatTimestamp" function there is a line for formatting the mysql:
case 'mysql':
$datestring = 'Y-m-d H:i:s';
break;
I think local parties just can define a static variable for this part?
Or maybe i totally misunderstood you and you said something i didnt notice?
