执行:
select ENDDATE from tabletest
返回:
ENDDATE
20140601020105
执行:
select to_date(ENDDATE , 'yyyy-mm-dd hh:mi:ss') from tabletest
返回:
to_date(ENDDATE , 'yyyy-mm-dd hh:mi:ss')
01-JUN-14
执行:
select to_char(to_date(ENDDATE , 'yyyy-mm-dd hh:mi:ss') , 'yyyy-mm-dd hh:mi:ss') from tabletest
返回:
to_char(to_date(ENDDATE , 'yyyy-mm-dd hh:mi:ss') , 'yyyy-mm-dd hh:mi:ss')
2014-06-01 02:01:05
执行:
select to_char(to_date(ENDDATE , 'yyyy-mm-dd hh:mi:ss') , 'yyyy-mm-dd hh:mi:ss') as ENDDATE from tabletest
返回:
ENDDATE
2014-06-01 02:01:05