CONCAT not working

Question

CONCAT not working

Navigation

#1 by (1 votes)

1

SELECT 
indicativo_ja_registrado,  
qra,
fez_contato, 
DATE_FORMAT(data_qso, '%d/%m/%y') AS data_qso, 
DATE_FORMAT(data_agora, '%d/%m/%Y') AS data_agora,
TIMESTAMPDIFF(YEAR, data_qso, data_agora) AS Anos,
TIMESTAMPDIFF(MONTH, data_qso + INTERVAL TIMESTAMPDIFF(YEAR, data_qso, data_agora) YEAR , data_agora) AS Mes,
TIMESTAMPDIFF(DAY, data_qso + INTERVAL TIMESTAMPDIFF(MONTH, data_qso, data_agora) MONTH , data_agora) AS Dias,
    Anos,
    Mes,
    Dias,
    CONCAT(Anos, ' Anos ', Mes, ' Mes e ', Dias, ' Dias') AS Extenso        
    quantidade_dias, 
hora_qso, 
faixa_simplex_MHz, 
faixa_MHz_qso_trans_repetidora, 
faixa_MHz_qso_trans_outras, 
nome_pais  
FROM qry_pesquisa_dois 
ORDER BY qry_pesquisa_dois.data_qso DESC;

The TIMESTAMPDIFF of 'Years', 'Month' and 'Days' has a satisfactory result, but CONCAT does not work.

mysql

asked by anonymous 01.12.2016 / 15:38

1 answer

How to limit display of records according to parameters Send image generated by PHP (GD) to Amazon S3

score 1 · Answer 1

Try this:

SELECT *, CONCAT(Anos, ' Anos ', Mes, ' Mes e ', Dias, ' Dias') AS Extenso FROM (       
SELECT 
    indicativo_ja_registrado,  
    qra,
    fez_contato, 
    DATE_FORMAT(data_qso, '%d/%m/%y') AS data_qso, 
    DATE_FORMAT(data_agora, '%d/%m/%Y') AS data_agora,
    TIMESTAMPDIFF(YEAR, data_qso, data_agora) AS Anos,
    TIMESTAMPDIFF(MONTH, data_qso + INTERVAL TIMESTAMPDIFF(YEAR, data_qso, data_agora) YEAR , data_agora) AS Mes,
    TIMESTAMPDIFF(DAY, data_qso + INTERVAL TIMESTAMPDIFF(MONTH, data_qso, data_agora) MONTH , data_agora) AS Dias,    
    quantidade_dias, 
    hora_qso, 
    faixa_simplex_MHz, 
    faixa_MHz_qso_trans_repetidora, 
    faixa_MHz_qso_trans_outras, 
    nome_pais  
FROM qry_pesquisa_dois 
ORDER BY qry_pesquisa_dois.data_qso DESC ) t;