Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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