Subject | Finding Diffrence in Time |
---|---|
Author | Sanjay Achar |
Post date | 2010-10-06T11:02:51Z |
Hi,
I'm trying to write a query in firebird 2.1.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.
With Regards,
Sanjay.
[Non-text portions of this message have been removed]
I'm trying to write a query in firebird 2.1.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.
With Regards,
Sanjay.
[Non-text portions of this message have been removed]