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" ?><"foo & bar"> |
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" ?><a>foo<b>bar</b></a> | <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 |