> Also, I have yet to discover how to create a TIME field from a
> TIMESTAMP in dialect 1, e.g. a computed field that shows TIME part of
> another TIMESTAMP field. Can it be done with CASTing? Is it done
> via UDF? How have people been dealing with time fields prior to
> dialect 3? With CHAR fields and manually chunking out substrings?
> Judging from the earlier lack of response to this question, either
> I'm missing the obvious solution or the solution is too complex to
> bother with??? Let me guess: just use dialect 3...

I still use Dialect 1 and so all the fields are date+time.
IBO has a facility to ignore either half if required, but I
tend just to work with them both as numbers. Time is just a
faction of a day, and you add and subtract fractions to give
offsets. Having to CAST is rare, I THINK I have do at times,
but normally I am just working with TDateTime in Builder5
and numbers in SQL.

Must get round to finding out what goes wrong when I finally
switch to Dialect 3 <g>

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services