From: Claudio Valderrama C. <cvalde@us...> - 2001-02-23 04:05:57
As you can see, not a bug. Not a requirement for basic compliance with the
standard, too. Do I convert the bug report into a request for enhancement?
Probably it can be reopened, since I closed it because it wasn't a bug. Read
From: Brown, Diane [mailto:Diane.Brown@...]
Sent: Jueves 22 de Febrero de 2001 23:13
To: 'Claudio Valderrama C.'
Subject: RE: TIME - TIME
Yes, SQL92 has INTERVAL datatype, but support for that type is not required
for Entry Level conformance.
(Actually, there are two types of INTERVALs: year-month intervals (in other
words, the value is expressed as a number of years and months), and day-time
intervals (value is expressed as a number of days, hours, minutes,
According to SQL92, the datatype of the result of the operations you list
below would be INTERVAL (assuming INTERVAL is supported).
Hope that helps,
>From: Claudio Valderrama C. [mailto:cvalde@...]
>Sent: Thursday, February 22, 2001 10:55 PM
>To: Diane Brown
>Subject: TIME - TIME
>Diane, currently IB6 does this trick in dialect 3, regarding data types
>DATE - DATE = DECIMAL(9,0) representing the number of days
>TIME - TIME = DECIMAL(9,4) representing number of seconds
>TIMESTAMP - TIMESTAMP = DECIMAL(18,9) representing days and
>fraction of day
> Is this correct? Does the standard defines an INTERVAL
>data type? If it
>does, should Firebird return INTERVAL instead of those numeric(x,y)
>quantities? Thanks for any feedback.
>Claudio Valderrama C.
>Ingeniero en Informática - Consultor independiente
Get latest updates about Open Source Projects, Conferences and News.