![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Fri, Nov 7 2008 10:41 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Fri, Nov 7 2008 10:44 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |