Skip to content

Oracle Communities

Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Transactional Business Intelligence

Categories

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

1335

Views

1

Comments

NIRMAL KUMAR L

NIRMAL KUMAR L Rank 3 - Community Apprentice

August 2017 in Oracle Transactional Business Intelligence

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

Tagged:

0

Comments

Manoj.Gupta Rank 1 - Community Starter

August 2017

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

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

0