Select from request where date

-3

how to make a selection from my request table with date field where the date is with date = ("Y-m-d) select only the month and show it in a td

    
asked by Alondra Esther Santiago Marque 06.11.2018 в 19:32
source

1 answer

0

To send for the month you can use the extract function, as long as your date is of the DateTime type, if it was of the String type you could use the function SUBSTR(str, position, [length]) , greetings

SELECT EXTRACT(MONTH FROM "2017-06-15");
    
answered by 06.11.2018 в 19:47