select t.type_id as typeId,

        t.type_name as typeName,

        t.type_order as typeOrder,

        t.type_link as typeLink,

        t.type_apply as typeApply,

        t.type_position as typePosition,

        to_char(t.begin_time, 'yyyy-mm-dd hh24:mi:ss') as beginTime,

        to_char(t.end_time, 'yyyy-mm-dd hh24:mi:ss') as endTime,

        t.image_path as imagePath

        from hwg_activity_type t

        where t.IS_DELETE='N'