Capture Month in date field

Question

Capture Month in date field

Navigation

#1 by (1 votes)

1

I have a date field in my MySQL database and it stores the date of type y-m-d which is already used in other queries, but now I need to capture only the month to make a sum.

The code I have is this

date_default_timezone_set('America/Sao_Paulo');
        $datamensal = date('m-d');
        $stw = mysql_query("SELECT SUM(valortotal) as total_mensal FROM pedidos WHERE data = '$datamensal'");

But it did not work .... Does anyone know the correct way to perform this action?

php mysql

asked by anonymous 04.11.2015 / 23:59

1 answer

How to get System.Generics.Collections.TList in a TList? REST API for converting CSV to JSON

score 1 · Answer 1

Use the month () MySQL to compare only the month with the desired value. There are other functions to extract a piece of date as year() , day() etc.

select month(now()) #retorna 11

or

$datamensal = date('m');
$stw = mysql_query("SELECT SUM(valortotal) as total_mensal FROM pedidos 
                    WHERE month(data) = '$datamensal' AND year(data) = year(now())")
       or die(mysql_error());

while($row = mysql_fetch_assoc($stw)){
   echo $row['total_mensal'] .'<br>';
}