its soo easy to work with them, with dateAdd, and dateDiff.
and as always the database is really thin, since your just storing numbers.
.02
tw
-----Original Message-----
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Friday, May 28, 2004 9:49 AM
To: CF-Talk
Subject: How do you *manage* time? (Add it, Subtract it, Track it)
Okay, so let's say you're using SQL Server, and you want to create an
application that was going to track time and do things like, eventually
multiply hours by currency (hourly rate by 1 hour 45 minutes) and add
several rows containing time to accumulate time spent, time remaining, etc,
and graphing it with CFChart (time spent vs time allocated), etc...
How would you store it and manipulate it in CF?
Do you store it as a DateTime object? What if you only add time on the front
end in fifteen minute increments (say, an "hour"dropdown with "1, 2, 3, 4,
5, 6, 7, 8" and a "minutes" dropdown menu with "00, 15, 30, 45" so you
could, say, select "4:45" to insert for your particular time entry) do you
use CF to create ODBC Date Time objects and pass those in, stored as a Date
Time object? But if you enter 4:45, how does it know you're adding a
*quantity* of time, rather than just saying "4:45 this afternoon"?
So, how *do* you store times if you want to add them and have the math work
right?
(For example (1:45 + 1:45)$10/hr = $35...like that)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
