Subject Re: [ib-support] time from timestamp
Author Lauri Zoova
Thomas Steinmaurer wrote:
>
> select extract (hour from mytimestamp) || ':' || extract (minute from mytimestamp) from MYTABLE2

Unfortunately thats only half good - '1:5' is not a very convincing time :(


BR,
Lauri