date 类型转为varchar

  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'

 

posted @ 2017-11-21 17:35  小啊菜鸡  阅读(1419)  评论(0编辑  收藏  举报