sqlingres

conveert dd.mm.yy into YYYYMM in Ingres db

I have date as DD.MM.YYYY how I can convert it into YYYYMM tql CONVERT() function doesn't work in ingres MySQL DATE_FORMAT also

Solution

  • select varchar(date_part('year','01102016'))+ shift(varchar(100+date_part('mos',date('01032016'))),-1); Here is how it was done