By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mwo (appdate TIMESTAMP WITH TIME ZONE);
INSERT INTO mwo(appdate) VALUES (TIMESTAMP '2021-09-28 01:23:45.123456789 EST');
1 rows affected
SELECT TO_CHAR(
appdate,
'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM'
) AS APPDATE
FROM mwo;
| APPDATE |
|---|
| 2021-09-28T01:23:45-05:00 |