データベース SQL PostgreSQL TO_CHAR(publish_date,"YYYY年mm月dd日') SQLite STRTIME(%Y年%m月%日',publish_date) SQL Server FORMAT(publish_date.'yyyy年MM月dd日') Oracle TO_CHAR(publish_date,"YYYY)||'年'||TO_CHAR(publish_date,'mm')|| '月'||TO_CHAR(publish_date,'dd')||'日' ray88.hatenablog.com