python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - to-char

Convert fractional number to Hexadecimal in Oracle

I have a table in database with fractional value- value 14.65 45 7458.34 34.69 4.7 34 I want to convert this fractional value to hexadecimal. But to_hex function only converts decimal value(14) and no...
test-img

s pragathi

sql

oracle

function

hex

to-char

Votes: 0

Answers: 1

Latest Answer

Split the values into the integer and the decimal parts and use TO_CHAR on them separately: WITH table_name (value) AS ( SELECT 15.33 FROM DUAL UNION ALL SELECT -15.33 FROM DUAL ) SELECT value, ...
test-img

MT0

Unable to Convert to Date

I am trying to return just the date from a datetime field When I run the Select Claus with just the first line, it work as expected. But when I add the second line, I receive From keyword not found er...
test-img

Winston Snyder

sql

oracle

to-char

Votes: 0

Answers: 1

Latest Answer

In Oracle, DATE is a reserved word and you cannot use it as an unquoted identifier. Either change your query to use a different identifier: SELECT To_Char(t.inc_date_time,'yyyy-mm-dd hh24:mi:ss') AS D...
test-img

MT0

Date data type in Oracle, 12 pm

How do I know if the hour 00:00:00 in a date field means 12 pm or means nothing, null, without looking for the data source of this table? FORMAT DD/MM/YYYY HH24:MI:SS DATE_WITHOUT_HOUR: 03/01/2022 00:...
test-img

Adriana

sql

oracle

date

sqldatatypes

to-char

Votes: 0

Answers: 2

Latest Answer

In Oracle, a DATE is a binary data type consisting of 7 bytes that represent century, year-of-century, month, date, hour, minute and second. It ALWAYS has those components and it is NEVER stored with ...
test-img

MT0

Posts

Questions

Blogs

Jobs