Oracle Transactional Business Intelligence

Syntax to converting 24 hour time format to 12 hour format in sql
Summary
Syntax to converting 24 hour time format to 12 hour format in sql
Content
Hi,
Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to 12 hour format(eg. 6:00 PM)
I tried the below query but it is not working.
SELECT
TO_CHAR(TIME_NORMAL_FINISH, 'hh:MI:SS:tt') "Date 12Hr"
FROM per_all_assignments_m
Thanks in advance,
Nirmal kumar
Comments
-
TO_CHAR(TIME_NORMAL_FINISH, 'HH:MI:SS AM')
http://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#NLSPG259