【SQL】oracle date类型格式化输出

来源:互联网 发布:office2016 mac 破解版 编辑:程序博客网 时间:2024/05/20 16:44
select fautocounter,fprocessid,FProTypeID,FProTypeName,FWorkstepName,FIsTimLim,FBeginTime,
to_char(FBeginTime,'yyyy/mm/dd hh24:mi:ss') as RFBeginTime,FEndTime,
to_char(FEndTime,'yyyy/mm/dd hh24:mi:ss') as RFEndTime,
FCalender,fmemo from jwxt.SY_LabConst_ProcessInfo where zt=1 order by fautocounter