----- Original Message -----
From: "Lauri Zoova" <dec@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, January 07, 2003 11:28 AM
Subject: Re: [ib-support] time from timestamp


> 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
:(


Then, you could use a SP to format hour and minutes for your needs.

>
>
> BR,
> Lauri
>