Mês com três letras DATE_FORMAT

[TeixeiraRamos 4]

No MySQL digitando:

SET GLOBAL lc_time_names=pt_BR;
SELECT
DATE_FORMAT(DATA, '%b') AS mes,
SUM(quantidade * valor) AS total
FROM tb_fornecedor
WHERE EXTRACT(YEAR FROM DATA) = 2013
GROUP BY mes
ORDER BY DATE_FORMAT(DATA, '%m/%Y');

Tenho o resultado:

| mes | total |

| Set | 585 |

| Out | 2700 |

| Nov | 3320 |

Mas aqui onde vou colocar de forma que no site fique igual ao MySQL?

strSql = "SELECT data, extract(month from data) AS mes, extract(year from data) AS ano FROM tb_fornecedor"
set rssomapormesano=Server.CreateObject("ADODB.RecordSet")
rssomapormesano.Open strSql, cn

[Motta 645]

http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-format

[TeixeiraRamos 4]

Olá Motta,

Desculpe, mas não consegui, ou melhor, observei que tem um SELECT:

SELECT CASE
WHEN MONTH(CURDATE()) = 01
THEN SUBDATE(CURDATE(), INTERVAL 31 DAY) /* Dec */
WHEN MONTH(CURDATE()) = 02
THEN SUBDATE(CURDATE(), INTERVAL 31 DAY) /* Jan */
WHEN MONTH(CURDATE()) = 03 AND (YEAR(CURDATE())%4 = 0)
THEN SUBDATE(CURDATE(), INTERVAL 29 DAY) /* Feb Leap Year */
WHEN MONTH(CURDATE()) = 03 AND (YEAR(CURDATE())%4 != 0)
THEN SUBDATE(CURDATE(), INTERVAL 28 DAY) /* Feb */
WHEN MONTH(CURDATE()) = 04
THEN SUBDATE(CURDATE(), INTERVAL 31 DAY) /* Mar */
WHEN MONTH(CURDATE()) = 05
THEN SUBDATE(CURDATE(), INTERVAL 30 DAY) /* Apr */
WHEN MONTH(CURDATE()) = 06
THEN SUBDATE(CURDATE(), INTERVAL 31 DAY) /* May */
.
.
.
.
.
.

Seria uma "Function"?