I'm using a select command where I get the month and date year as follows:
extract(year from D.dt_ficha) + extract(month from D.dt_ficha)
But instead of appearing like this: 201711 November 2017, it is adding 2017 + 11 2028 .
How to fix?
I solved it like this:
to_char(D.dt_ficha, 'YYYYMM') as data,
Try this:
SELECT extract(year from D.dt_ficha) || '' || extract(month from D.dt_ficha)
from D
Where D would be your table;
For me it worked correctly.
You can also use the date_trunc function:
date_trunc('month', TIMESTAMP '2001-02-16 20:38:40')
you will get as a result:
2001-02-01 00:00:00
Try using "||"
extract(year from D.dt_ficha) || extract(month from D.dt_ficha)