SELECT TO_CHAR(NOW(),‘YYYY"年"MM"月"DD"日"’)
SELECT TO_CHAR(CAST(‘2022-10-10’ AS DATE),‘YYYY"年"MM"月"DD"日"’)
SELECT TO_CHAR(CAST(‘2022-10-10 12:00:00’ AS TIMESTAMP),‘YYYY"年"MM"月"DD"日" HH24:MI’)
PG库日期转换为xxxx年xx月xx日格式
最新推荐文章于 2023-08-14 00:24:21 发布
SELECT TO_CHAR(NOW(),‘YYYY"年"MM"月"DD"日"’)
SELECT TO_CHAR(CAST(‘2022-10-10’ AS DATE),‘YYYY"年"MM"月"DD"日"’)
SELECT TO_CHAR(CAST(‘2022-10-10 12:00:00’ AS TIMESTAMP),‘YYYY"年"MM"月"DD"日" HH24:MI’)