SQLines Tools mysql-to-db2
https://www.sqlines.com/
2026-06-10T09:17:21+00:00SQLines Tools
https://www.sqlines.com/
https://www.sqlines.com/lib/images/favicon.icotext/html2013-02-14T15:47:50+00:00DATE_FORMAT - Convert Date to String - MySQL to IBM DB2 Migration
https://www.sqlines.com/mysql-to-db2/date_format?rev=1360856870&do=diff
In MySQL, DATE_FORMAT function converts a DATE or DATETIME value to string using the specified format. In DB2, you can use VARCHAR_FORMAT function.
Note that the DATE_FORMAT and VARCHAR_FORMAT use different format strings.
MySQL:
-- Convert the current date to YYYYMM format
SELECT DATE_FORMAT(NOW(), '%Y%m');
# 201302