SELECT * FROM TABLE
where extract(year from order_date) = ‘2018’
and extract(month from order_date) = ’01’
Comment extraire l’année et le mois d’une date sur Oracle?
- Advertisement -
SELECT * FROM TABLE
where extract(year from order_date) = ‘2018’
and extract(month from order_date) = ’01’
