Syntax to converting 24 hour time format to 12 hour format in sql

Nirmal Kumar L

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

Manoj.Gupta

TO_CHAR(TIME_NORMAL_FINISH, 'HH:MI:SS AM')

http://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#NLSPG259