将日期格式化为字符串 [英] Format date to string

问题描述

我正在尝试将 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;

这篇关于将日期格式化为字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！