Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Syntax to converting 24 hour time format to 12 hour format in sql
Nirmal Kumar L
Rank 3 - Community Apprentice
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
0
Comments
-
TO_CHAR(TIME_NORMAL_FINISH, 'HH:MI:SS AM')
http://docs.oracle.com/database/121/NLSPG/ch4datetime.htm#NLSPG259
0