Sanjay Achar schrieb am 06.10.2010 um 16:21 (+0530):

>
>   I'm trying to write a query in firebird 1.2.3 database, where i want
> to determine the difference in two times which are stored as varchar.
>
> Right now I'm doing this by casting the varchar into time then
> extracting the hour and minute part from that time and then
> calculating the diffrence by multiplying 60 to hour part and adding it
> to minute part.
>
> Are there any alternatives for this.

SELECT DATEADD( DAY, 3, CURRENT_DATE) FROM RDB$DATABASE;

And there's also DATEDIFF.

You need FB 2.0 or better. Version "1.2.3" which you're referring to
does not exist.

--
Michael Ludwig