> Let's say a table was going to contain "AllocatedTime" which would be the
> total time allocation for a task, say...an hour, possibly 8, maybe 16, maybe
> even a half hour or 45 minutes...you get it, a range of hours and minutes,
> and another table was going to contain separate entries to track progress
> and "Time Used"...the idea being at any given time, I could query for
> "allocated time", subtract the sum of all "used time" to easily display
> "remaining time".
>
> My question is, do you define the datatype in the database as a datetime
> object?
No, as an INTERVAL.
> If it helps, I'm using SQL Server 2000.
That does not help ;-)
I think if I had to use a database that doesn't support
intervals, I would use seconds in an integer field.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
