Subject | Time calculation, with time response |
---|---|
Author | Roberto Carlos |
Post date | 2008-11-10T01:58:34Z |
How can I calculate this?
Select
time '15:00:0.000' - time '14:04:42.000',
cast('15:00:0.000' as time) - Cast('14:04:42.000' as time),
cast(3318.0000 as time),
cast(cast('15:00:0.000' as time) - Cast('14:04:42.000' as time) as time)
From rdb$Database;
The first two even work, but I can not transfom them into time fields.
[Non-text portions of this message have been removed]
Select
time '15:00:0.000' - time '14:04:42.000',
cast('15:00:0.000' as time) - Cast('14:04:42.000' as time),
cast(3318.0000 as time),
cast(cast('15:00:0.000' as time) - Cast('14:04:42.000' as time) as time)
From rdb$Database;
The first two even work, but I can not transfom them into time fields.
[Non-text portions of this message have been removed]