Db2 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT xmlcast('<"foo & bar">' AS xml) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>&lt;"foo &amp; bar"&gt;

SELECT xmlcast('' AS xml) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>

SELECT xmlcast(NULL AS xml) FROM sysibm.sysdummy1;

1

null

SELECT xmlcast(to_date('29/05/2024','dd/mm/yyyy') AS XML) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>2024-05-29T00:00:00

SELECT xmlcast(timestamp('2024-05-22 12:33:42') AS XML) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>2024-05-22T12:33:42

SELECT xmlcast(TO_UTC_TIMESTAMP(TIMESTAMP'2024-06-03 10:45:46.883877', 'Europe/Berlin') 
  AS xml) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>2024-06-03T08:45:46.883877

SELECT xmlcast(42 AS XML) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>42

SELECT xmlcast(427353542 AS XML) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>427353542

SELECT xmlcast(4273535420162021 AS XML) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>4273535420162021

SELECT xmlcast(42.0073 AS XML) FROM sysibm.sysdummy1;

1

<?xml version="1.0" encoding="UTF-8" ?>42.0073

SELECT 
  xmlcast('<a>foo<b>bar</b></a>' AS xml),
  xmlcast(xmlcast('<a>foo<b>bar</b></a>' AS xml) AS VARCHAR(30))
FROM sysibm.sysdummy1;

1
2

<?xml version="1.0" encoding="UTF-8" ?>&lt;a&gt;foo&lt;b&gt;bar&lt;/b&gt;&lt;/a&gt;
<a>foo<b>bar</b></a>

SELECT xmlcast(xmlcast('42' AS xml) AS INTEGER) FROM sysibm.sysdummy1;

1

42

SELECT xmlcast(xmlcast('2024-05-22' AS xml) AS DATE) FROM sysibm.sysdummy1;

1

2024-05-22

SELECT xmlcast(xmlcast('42.7385832016' AS xml) AS DECIMAL(10,2)) FROM sysibm.sysdummy1;

1

42.73