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
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

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

1373

Views

1

Comments

NIRMAL KUMAR L

NIRMAL KUMAR L Rank 3 - Community Apprentice

Aug 19, 2017 9:39AM 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

Aug 20, 2017 12:21AM

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

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

0