I want to use LIST to get a list of times from a TIMESTAMP. I only want it to the minute. Anyone come up with anything better than

cast(cast(when as TIME)as varchar(5))

It works, I just want to know if there's anything better.

Roy Lambert

Roy,

<< I want to use LIST to get a list of times from a TIMESTAMP. I only want
it to the minute. Anyone come up with anything better than

cast(cast(when as TIME)as varchar(5))

It works, I just want to know if there's anything better. >>

I would use this:

cast(extract(hour from when) AS varchar(2)) + ':' + cast(extract(minute from
when) AS varchar(2))

--
Tim Young
Elevate Software
www.elevatesoft.com