Untitled
unknown
plain_text
a year ago
561 B
4
Indexable
SELECT LPAD(FC5DIASTOHMS((DTAHORAFIMGER - DTAHORAINIGER), 'H'), 2, '0') || ':' || LPAD(FC5DIASTOHMS((DTAHORAFIMGER - DTAHORAINIGER), 'M'), 2, '0') AS TEMPO FROM (SELECT MIN(A.DTAHORAINIGER) DTAHORAINIGER, MAX(A.DTAHORAFIMGER) DTAHORAFIMGER FROM EFD_LOG_GERACAO A WHERE A.SEQGERACAO = pnSeqGeracao ORDER BY A.SEQUENCIA); SELECT DISTINCT A.SEQGERACAO, A.DTAGERACAO FROM EFD_LOG_GERACAO A WHERE A.CODIGO_LAYOUT = pnCodigoLayout AND A.NROEMPRESA = pnNroEmpresa ORDER BY A.DTAGERACAO DESC
Editor is loading...
Leave a Comment