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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert a time field in Oralce to a number

Status
Not open for further replies.
jimmy80

jimmy80

Programmer
May 7, 2003
13
0
0
GB
Hi,

I need to convert a time field in the format hh24:mi:ss to a number in the format hhmiss - I have tried using to the to_number function but amn't having any success...
Any chance anyone knows how I can do this?

Thanks for your help,
jim
 
Sort by date Sort by votes
Try, TO_CHAR(<YOUR DATE>, 'hhmiss') though I can't understand how to work with this number :)

Regards, Dima
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spd800c
  • Locked
  • Question
GIF icons not showing at runtime in Developer 10g
Replies
0
Views
69
spd800c
spd800c
BJCooperIT
  • Locked
  • Question
Problem running a form from Forms Builder
Replies
2
Views
88
BJCooperIT
BJCooperIT
Maahjoor
  • Locked
  • Question
apllication screen adjustment problem
Replies
0
Views
55
Maahjoor
Maahjoor
faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
83
oradba101
oradba101
deeptic
  • Locked
  • Question
Displaying Date &amp; Time when the form is run
Replies
1
Views
52
sem
sem

Part and Inventory Search

Sponsor

Back
Top