Comment extraire l’année et le mois d’une date sur Oracle?

0
107
oracle-extract-function
oracle-extract-function

SELECT * FROM TABLE
where extract(year from order_date) = ‘2018’
and extract(month from order_date) = ’01’

LEAVE A REPLY

Please enter your comment!
Please enter your name here