I have problem when my table have field with date type. When the data is null will display 01-01-1970. Would you like to give me a suggest to solve the problem?
FYI, the database is Oracle.
Solution could be to use on_data_display event handler and on getting date value 01-01-1970, replace it with ''
Code would be something like following:
$e["on_data_display"] = array("filter_display", null, true);
foreach($data["params"] as &$d)
foreach($d as $k=>$v)
if ($d[$k] == "01-01-1970")
$d[$k] = "";
I have a bit similar problem about null date from database that will display 01-01-1970 but it is after it has been export to excel file..how can I solve the problem?
Is it the same answer as above? where should I put the code?
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!