nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
More Solutions
Oracle Transactional Business Intelligence Forum

Syntax to converting 24 hour time format to 12 hour format in sql

NIRMAL KUMAR L

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

Find more posts tagged with

Answers

BI Publisher Data Models

Report Layouts

Report Output

Report Delivery

Comments

Manoj.Gupta

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

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