|Subject||Re: [firebird-support] Finding Diffrence in Time|
> I'm trying to write a query in firebird 2.1.3 database, where i wantWhy are you storing them als VARCHAR in the first place? If they are always TIME, then store them as TIME.
> to determine the difference in two times which are stored as varchar.
> Right now I'm doing this by casting the varchar into time thenSure, you can use DATEDIFF: http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-datediff.html
> 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
> Are there any alternatives for this.
GRATIS: Spider-Man 1-3 sowie 300 weitere Videos!
Jetzt freischalten! http://portal.gmx.net/de/go/maxdome