You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

25
Views
1
Comments
edited Aug 19, 2017 9:39AM in General Transactional Reporting (OTBI) 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!