Extract year and month from timestamp(6)

Question

I have database, where i have inserted timestamps(6) in this format : 18-AUG-14 02.49.27.000000000 PM .

I want to extract it into this: 2014-08

Its called ISO 8601

Answer 1

You'll need to use the to_char function to extract the year-month from timestamp.

select to_char(timestamp, 'yyyy-mm') from your_table