| Subject | Re: [ib-support] Subtract two TimeStamp-Fields |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2001-02-26T14:04:11Z |
Guido,
if I remember correctly TimeStamp in IB6.0 is the equivalent of Date in
IB5.6 - and that would give you the difference in days, not in seconds. Try
something like
"Select (end-start)*24*60*60 from table" to get the number of seconds and
worry about the casting once you get the calculation to work.
HTH,
Set
if I remember correctly TimeStamp in IB6.0 is the equivalent of Date in
IB5.6 - and that would give you the difference in days, not in seconds. Try
something like
"Select (end-start)*24*60*60 from table" to get the number of seconds and
worry about the casting once you get the calculation to work.
HTH,
Set