Ways to take only the month of the dates recorded in the database

Question

I need to take only the months of the dates of a given field that is in my database, however, preferably without using SELECT MONTH.

That way, we get the current month of today’s date:

$mes_atual = date('m'); 
echo $mes_atual; //Seria exibido "06" - hoje é dia 22/06/2020

I was looking for something similar, but with the bank dates, I’m going to leave an example that I know doesn’t make much sense, but just so you understand better.

My example code:

   $sql = "SELECT prazo FROM comercio";
   $resultado = mysqli_query($con, $sql);

   while ($row= mysqli_fetch_array($resultado)) {
  
   $mes_atual = date('m')$row['prazo'];  //Aqui pegaria somente o mês das datas vindas do banco

   }

Is it possible I rescue these months from database otherwise? without being using the SELECT MONTH, if NAY, why?

Answer 1

$sql = ("SELECT prazo FROM comercio");

$resultado = mysqli_query($con, $sql);

if (mysqli_num_rows($resultado) > 0) {

    while($row = mysqli_fetch_array($resultado)) {
    
        //retorna um novo objeto DateTime.
        $date = date_create($row['prazo']);
        
        //retorna uma data formatada de acordo com o formato especificado
        $mes_atual =  date_format($date, 'm');
        $data = date_format($date, 'd/m/Y');
        echo $mes_atual." -  Prazo ". $data;
        echo "<br>\n";
        
    }   
    
}

Answer 2

I had nowhere to run, and I ended up using the SELECT MONTH, I didn’t know I could select a field twice in one SELECT, follows my answer below that it worked:

$sql = "SELECT comercio.*, date_format(comercio.prazo,'%m') as mes_prazo, tabela1.nome, tabela2.preco
FROM comercio, tabela1, tabela2
WHERE comercio.nome = tabela1.nome";

$resultado = mysqli_query($con, $sql);

while ($cont = mysqli_fetch_array($resultado)) {

echo $cont['mes_prazo']; //Aqui exibe todos os meses registrados no banco, que eu precisava usar fazer uma condição. Além desses meses são exibidos as datas completas...

}

Answer 3

Use the date_format function

https://www.w3schools.com/sql/func_mysql_date_format.asp

select date_format(now(),'%m')