Avatar of Scott Palmer
Scott Palmer
Flag for United States of America

asked on 

Using PL/SQL for Oracle, convert date to year/month

I want to convert the date to a year/month.  An example would be the date is 01/10/2017 and converted to 201701.

And so any date within January would convert to 201701.  Any date within February would be 201702 etc.

Can this be done and if yes, how?

Thanks, Scott
Oracle DatabaseSQL

Avatar of undefined
Last Comment
Scott Palmer

8/22/2022 - Mon