alonzo
Well-known member
Ciao, non riesco a far visualizzare in custom_function il tempo trascorso tra due datetime con la funzione che segue.
[pre]
<?php
$Query = "SELECT NUM,
DATE_FORMAT( Ora_entrata, '%d-%m-%Y %k:%i:%s' ) AS Ora_entrata,
DATE_FORMAT( Ora_uscita, '%d-%m-%Y %k:%i:%s' ) AS Ora_uscita,
TIMEDIFF( Ora_uscita , Ora_entrata ) AS Tempo_impiegato
FROM REPSVET_2019
ORDER BY REPSVET_2019.Ora_entrata ASC";
?>
[/pre]
Ho provato anche a creare una vista (che funziona) ma non riesco ad importarne la colonna Tempo_impiegato da "Field type specific parameters" Lookup table...da inserire in un terzo campo.
E' realizzabile?
[pre]
You are using DaDaBIK version 9.0-Monterosso enterprise, installed on 25.11.2018 (installation code: 126015952a0b5455cd), the latest version of DaDaBIK is 9.2-Monterosso released on 07.11.2018
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.0.31
mysql version: 5.6.41-84.1-log
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36
[/pre]
[pre]
<?php
$Query = "SELECT NUM,
DATE_FORMAT( Ora_entrata, '%d-%m-%Y %k:%i:%s' ) AS Ora_entrata,
DATE_FORMAT( Ora_uscita, '%d-%m-%Y %k:%i:%s' ) AS Ora_uscita,
TIMEDIFF( Ora_uscita , Ora_entrata ) AS Tempo_impiegato
FROM REPSVET_2019
ORDER BY REPSVET_2019.Ora_entrata ASC";
?>
[/pre]
Ho provato anche a creare una vista (che funziona) ma non riesco ad importarne la colonna Tempo_impiegato da "Field type specific parameters" Lookup table...da inserire in un terzo campo.
E' realizzabile?
[pre]
You are using DaDaBIK version 9.0-Monterosso enterprise, installed on 25.11.2018 (installation code: 126015952a0b5455cd), the latest version of DaDaBIK is 9.2-Monterosso released on 07.11.2018
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.0.31
mysql version: 5.6.41-84.1-log
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36
[/pre]