Hi,

I would like to show the formatted date from millisecond column (start_time) as below.

SELECT
id,
deviceId,
jobOwnner,
DATE_FORMAT(FROM_UNIXTIME(start_time/1000), '%d/%m/%y'),
FROM_UNIXTIME(start_time/1000)
FROM
JobLog;

I had tested this with Ari DataTable and it doesn't show any data in the formatted date column. Any thing I had don't wrong with the SQL? It work with MySQL client.


Thanks,
Dennis

Hello,

Could you provide a link to a page where we can see the problem and send screenshot(s) of module settings page by email?

Regards,
ARI Soft