ALTER TABLE TBPDV_CONFERENCIA_TROCA_ITEM
    ADD DATA DATE DEFAULT CURRENT_DATE NOT NULL;


UPDATE TBPDV_CONFERENCIA_TROCA_ITEM T SET T.DATA = CAST(T.DATAHORA AS DATE);
