SELECT CONCAT(LPAD(FLOOR(extra_ot/60),2,'0'),':',LPAD((extra_ot MOD 60 ),2,'0'),':00') AS Extra_O
SELECT CONCAT(cast(LPAD(FLOOR(extra_ot/60),2,'0') as char(20)),':',cast(LPAD((extra_ot MOD 60 ),2,'0') as char(20)),':00') AS Extra_O
Adding this in connection settings did the trick : ;Allow User Variables=True;Respect Binary flags=false
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)