I think there are different questions you should be asking yourself. I can see how from your perspective you would prefer to go to one of the top two full-time MBA programs in New York City to facilitate a career switch. However, the full-time MBA programs are more competitive. So, if you are not competitive for the full-time MBA programs would Columbia's Executive MBA Program or either NYU Stern's Part- or Executive- MBA programs help you make the switch over the full-time MBA programs for less prestigious programs in NYC. So, in doing your due diligence, contact Stern's Career Center for Working Professionals (CCWP) -
https://www.stern.nyu.edu/portal-partner ... fessionals - and Columbia's EMBA Career Management -
https://www8.gsb.columbia.edu/programs-a ... management - to really kick the tires on the degree to which they will help you in this transition. Ask if the current policy on NYU Stern part-time students allows them to interview for full-time MBA positions.
Two years ago, I had a 29-year old client who wanted to go to a full-time MBA program - she was rejected by Duke's Full Time MBA Program, yet accepted to Wharton's Executive MBA Program. In a perfect world, she would have rather attended Wharton's Full Time MBA Program but she was not competitive for it. I do not know the overall strength of your candidacy, but attending NYU Stern's Part Time MBA Program might be better for you long-term than attending say City University of New York, Baruch College MBA or a comparable local New York City program.
FYI - For a primer on Different MBA Programs refer here -
https://www.mbaprepadvantage.com/blog/di ... ram-types/
Good luck,