| start time and end time... finding minutes [message #81569] |
Mon, 03 March 2003 14:36  |
kim
Messages: 116
Registered: December 2001
|
Senior Member |
|
|
hello,
i am building a form which requires the user to enter a start time (probably a format such as 7:00 AM) and an end time. when they commit the form, the difference will be found in minutes and the number of minutes inserted into the database. i would like some ideas on how to do this, i have never worked with time before. thank you very much for any suggestions.
|
|
|
|
|
|
| Re: start time and end time... finding minutes [message #81580 is a reply to message #81569] |
Tue, 04 March 2003 06:15  |
kim
Messages: 116
Registered: December 2001
|
Senior Member |
|
|
|
thank you for your help... however i am not sure this applies to me, isn't this for finding actual time during runtime? i am trying to enter start and end times for a class in school and then find how many minutes long the class is.
|
|
|
|
| Re: start time and end time... finding minutes [message #81587 is a reply to message #81580] |
Tue, 04 March 2003 09:58 |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
|
Oracle dates automatically store time. When you subtract one date from another the result is in days OR FRACTION THEREOF. Multiply the difference by 1440 to get elapsed minutes (24 hours times 60 minutes) or by 86400 (24 hours * 60 minutes * 60 seconds) to get elapsed seconds.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
