Help with Integer to Char to Datetime stamp

[sqlPower]

In an ORACLE database, I have 2 fields
Categorization_Hours_Due, datatype integer, and
Categorization_Minutes_Due, also an integer.

I want to convert these to a datetime.
For example: Categorization_Hours_Due = 16
Categorization_Minutes_Due = 52

As a Timestamp, I want 16:52PM
I am using TOAD.

Thank you.

 

[Andrzejek]

Would that help: Convert number to timestamp or how to convert a number into timestamp in oracle/sql


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[SkipVought]

Except an Oracle Timestamp does not mix 24 hour with AM/PM.

Furthermore, is Categorization_Hours_Due and Categorization_Minutes_Due referencing a point in time or a DURATION?

If it really is a DURATION of so many hours and minutes, then a timestamp (point in time) would be incorrect.

A point in time Timestamp, includes a DATE and TIME.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!