| Subject | Finding Diffrence in Time |
|---|---|
| Author | Sanjay Achar |
| Post date | 2010-10-06T10:51:43Z |
Hi,
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.
With Regards,
Sanjay.
[Non-text portions of this message have been removed]
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.
With Regards,
Sanjay.
[Non-text portions of this message have been removed]