Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- 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