oracle sql server datetime overflow

use to_char

    select to_char(Markethistory.Dtoftran,'DD-MM-YYYY') from Markethistory;