Following is the SQL for Time format.

db2 -v "select char(date(current timestamp),USA)|| ' ' || char(time(current timestamp))||' '||SUBSTR((char(time(current timest
amp),USA)),7,2) from sysibm.sysdummy1"

The above work well, but please see below...

The above SQL when run ..shows as below.. in the 24 hour format
09/08/2005 20.04.20 PM

Instead of the 12 hour format.
09/08/2005 08:04:20 PM

Can this be achieved in DB2 ?????
Tried all the functions.

Please let me know.

Thank You
Bollin99

See if CHAR scalar function helps

Cheers
Sathyaram

See if CHAR scalar function helps

Refer documentation for details

Cheers
Sathyaram

select char(date(current timestamp),USA)|| ' ' || char(time(current timestamp),USA) from sysibm.sysdummy1

This works! gives time as 02/09/2006 07:54 PM