Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 14 of 14 total |
Time Difference in HH:MM:SS |
Thu, Sep 24 2020 9:47 AM | Permanent Link |
Fernando Dias Team Elevate | Roy,
There are never milliseconds when we cast it as INTERVAL DAY TO SECOND. Also, 12 was the size Ian asked for. -- Fernando Dias [Team Elevate] |
Thu, Sep 24 2020 6:45 PM | Permanent Link |
Ian Branch | Hi Team,
I have Roy's solution working and it gives the absolute result fine. What I would like now is for the Days to be left padded with '0'. So, instead of getting 1:12:34:45, I would have 001:12:23:45. Instead of 12:23:45:56, I would have 012:23:45:56. Etc. This is so the column is consistently formatted. It's the OCD in me. Regards & TIA, Ian |
Thu, Sep 24 2020 6:47 PM | Permanent Link |
Ian Branch | Hmmm. I just noticed a Duration of "366:0:28:01" instead of "366:00:28:01" 24 hour day.
|
Mon, Sep 28 2020 6:37 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
What did you decide - go with the simple approach or move to a UDF? If the latter do you need any help? Roy Lambert |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |