データベース | 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')||'日' |