问题描述
我已经研究了Cast和Convert，但是找不到解决方法。我需要将四位数转换为小时格式。例如，0800将变为8:00或1530将变为15:30。我无法使用函数，正在使用InterSystem的CacheSQL。有什么建议么？
I have looked into Cast and Convert, but I cannot find a way to do this. I need to convert four digits into an hour format. For instance, 0800 would become 8:00 or 1530 would become 15:30. I cannot use functions, I'm using a InterSystem's CacheSQL. Any suggestions? Thanks in advance!
编辑：
如果方便的话，我可以将四位数除以100得到原始1500的值，例如15 ，或从0830开始的8.30。这是否使转换为hour：minute格式更容易？
If it is any more convenient, I can just divide the four digits by one hundred to get values like 15 from original 1500, or 8.30 from 0830. Does this make converting to hour:minute format easier?
推荐答案
对于CacheSQL，您可以执行以下操作：
For CacheSQL, you can do this:
SELECT {fn TRIM(LEADING '0' FROM LEFT(col_name, 2) || ':' || RIGHT(col_name, 2)) }
FROM table_name
这篇关于将四位数转换为小时格式SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！