Subject | Subtract two TimeStamp-Fields |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2001-02-26T13:51:53Z |
I have two fields in a table
Start TimeStamp (for example 19.02.2001 8:00)
End TimeStamp (for example 20.02.2001 9:00)
and I want the duration between these two fields. I tried something like
that
cast ((End-Start) as Numeric(9,3))
to get the seconds, that has gone by between these two points. But I get
an conversion error. Can anybody help me.
Guido.
Start TimeStamp (for example 19.02.2001 8:00)
End TimeStamp (for example 20.02.2001 9:00)
and I want the duration between these two fields. I tried something like
that
cast ((End-Start) as Numeric(9,3))
to get the seconds, that has gone by between these two points. But I get
an conversion error. Can anybody help me.
Guido.