Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to convert day to hours?

Status
Not open for further replies.
Bartec

Bartec

Programmer
Jan 21, 2005
54
PL
Hi

I need change day to hour from my date for example:
I have following date format: 01 22:43:22 - where 01 is a day. Now I want to include (add) this day to hours so I want to have: 46:43:22.
I'm using oracle database.

Thanks for any help and tips

Best regards

Bartec

 
Sort by date Sort by votes
I'm using oracle database
So, why not posting in an oracle forum ?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bill Doe
  • Locked
  • Question
PDO UPDATE too long to execute
Replies
1
Views
196
mikrom
mikrom
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
206
szeiss
szeiss
JustATheory
  • Locked
  • Question
Convert Date of Birth to Age, results a negative number
Replies
5
Views
189
JustATheory
JustATheory
dEX2340
  • Locked
  • Question
Using CONVERT in CASE WHEN
Replies
4
Views
171
dEX2340
dEX2340
faimuj
  • Locked
  • Question
How to update a field while inserting a row
Replies
3
Views
142
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top