For example:

select extract (hour from mytimestamp) || ':' || extract (minute from mytimestamp) from MYTABLE2


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: Lauri Zoova [mailto:dec@...]
> Sent: Tuesday, January 07, 2003 1:36 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] time from timestamp
>
>
> Hi!
>
> How can i get time portion of timestamp excluding seconds? (Besides
> writing an udf that is..)
>
> using select cast(ts_field as time) from table, i get seconds also.
> using select cast(cast(ts_field as time) as char(5) from table, i get
> 'string truncation error or aritm...'.
>
>
> BR,
> Lauri
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>