格式化日期到字符串
问题描述:
我正在尝试将db2日期格式化为字符串为YYYY / MM / DD。
I'm trying to format a db2 date into a string as "YYYY/MM/DD".
我到目前为止最好的是:
The best I got so far is:
SELECT CAST(YEAR(MYDATE) AS VARCHAR(4)) || '/'
|| CAST(MONTH(MYDATE) AS VARCHAR(2)) || '/'
|| RIGHT('00' || CAST(DAY(MYDATE) AS VARCHAR(2)), 2) FROM MYCALENDAR
Is there a better, terser way to do this?
ps:使用区域设置来处理不是一个选项。
ps: Toying around with locales is not an option.
答
根据 IBM文档以下内容应该有效:
According to the IBM documentation the following should work:
SELECT VARCHAR_FORMAT(MYDATE, 'YYYY/MM/DD') FROM MYCALENDAR;