TO_CHAR()函数,转换日期格式
学习笔记。。。
例:
select CREATE_TIME from "BIZ_PLATFORM_USER"."BIZ_MESSAGE_NOTIFICATION"
结果:
2017-01-20 00:00:00.000000
2020-05-06 13:22:43.000000
2017-12-30 00:00:00.000000
2021-01-05 00:00:00.000000
2018-04-24 00:00:00.000000
用 TO_CHAR()函数转换后查询:
例:
select TO_CHAR(CREATE_TIME,'yyyy-MM-dd') from "BIZ_PLATFORM_USER"."BIZ_MESSAGE_NOTIFICATION"
结果为:
2017-01-20
2020-05-06
2017-12-30
2021-01-05
2018-04-24