| Time [message #124846] |
Tue, 21 June 2005 16:07  |
mlodymaytek
Messages: 9
Registered: June 2005
Location: poland
|
Junior Member |
|
|
Forms 9i, win xp, DB 9i
I am doing a form with time. And i want that user could only give start time HH:mi and end time HH:mi and calculate how log that is. I want to store it without DD-MM-YYYY because I dont need it.
What type I should use for that??
|
|
|
|
| Re: Time [message #124886 is a reply to message #124846] |
Wed, 22 June 2005 02:10  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Either use datetime fields and let the system do the mathematics for you, or use two number fields with ranges set, and do the work yourself. I choose the first one.
If you don't want them to have to enter the day, month, and year information, don't display it. Just use a 'HH24:MI' format on your datetime fields.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
