How to recover date field (mysql+php)?

Question

I have a date field in mysql, the problem is that I can’t recover it by selecting it and printing only appears its name (date).

$dados = mysqli_query($conexao, "SELECT 'data' FROM tabela");

$res_data = mysqli_fetch_array($dados);

echo $res_data[0];

Exit --- data.

Answer 1

Remove the quotes from the column name:

$dados = mysqli_query($conexao, "SELECT data FROM tabela");