Subject | Re: [ib-support] time from timestamp |
---|---|
Author | Lauri Zoova |
Post date | 2003-01-07T13:28:44Z |
Thomas Steinmaurer wrote:
BR,
Lauri
>Unfortunately thats only half good - '1:5' is not a very convincing time :(
> select extract (hour from mytimestamp) || ':' || extract (minute from mytimestamp) from MYTABLE2
BR,
Lauri