|Subject||Re: [firebird-support] Re: Hourly rate|
> > No, this isn't a "time", it's a "duration" or "interval". SomethingYou can do maths on it, I know.
> > Firebird doesn't support.
> Firebird supports mathmatic, it is enough.
But the "time" of 16:00 afternoon divided by 2 does
not give you a "time" value of 08:00 in the morning.
Let alone if you have the date of today at a certain
Oct 21 15:00 (which is a "date and time") minus 2 hours
(which is NOT a time) gives you Oct 21, 13:00.
See the "2 hours" part - that is a "duration", not a time.
Now, remove 1.5 days. You'll get Oct 20, 03:00.
But 1.5 days - how would you display that? No such thing
in a "date and time" format, is there?
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!