Thomas Steinmaurer wrote:

>
> If you are using Firebird you could use the built-in SUBSTRING function.
> (otherwise look for a equal function in one of the available UDF libs)
>
> For example:
> select substring((cast(mytimestamp as time)) from 1 for 5) from MYTABLE2

Not THAT works! Thanks!


BR,
Lauri