AM and PM format in CURRENT_TIMESTAMP in Teradata

In order to differentiate AM and PM format in the current time stamp, the below code can be used.

The format Y4-MM-DDBHH:MI:SSBT will set the format here.

SELECT CAST(CAST(CURRENT_TIMESTAMP(0) AS FORMAT 'Y4-MM-DDBHH:MI:SSBT') AS CHAR(22))