larisboy 最近的时间轴更新 larisboy 最近的时间轴更新 |
larisboyV2EX 第 357703 号会员，加入于 2018-10-22 17:46:33 +08:00 |
| 各位大哥请问现在大陆还是注册 ChatGTP 吗 问与答 • larisboy • 118 天前 • 最后回复来自 nbweb | 3 |
| 请问大佬一个问题 [关于 Taro+vue3+webpack5] 问与答 • larisboy • 178 天前 |
| 请问大佬一个问题 [关于 Clickhouse] 问与答 • larisboy • 352 天前 • 最后回复来自 leonhao | 11 |
| 请问各位 V 友们第一次去别人新买的房子最好带点什么过去 问与答 • larisboy • 2021-12-01 11:41:53 AM • 最后回复来自 happuiness | 19 |
| spring mvc + jdbcTemplate 老项目测试事务时发现日志显示 rollback 了但是数据还是写库了 程序员 • larisboy • 2021-02-23 10:15:06 AM • 最后回复来自 chanchan | 1 |
| JDBCTransaction rollback 无效但是又不报错，求大佬们支招 问与答 • larisboy • 2021-02-22 20:01:58 PM • 最后回复来自 larisboy | 2 |
| 迫于穷，又想入个 4K 屏幕玩玩，有的大哥带价 二手交易 • larisboy • 2021-01-20 09:44:34 AM • 最后回复来自 wangtxxl | 12 |
| 迫于电脑带不动，想入手一台 nuc8 i7 或者 nuc 10 i7 黑果，有的大哥带价 二手交易 • larisboy • 2021-01-04 15:36:14 PM • 最后回复来自 FakerLeung | 15 |
| 再见了 V 友们，我要回去高考了，盲猜第一题选 C 问与答 • larisboy • 2020-07-07 16:18:09 PM • 最后回复来自 rzWack | 14 |
| 出来薅羊毛啦，免费领半年京东会员，每个月有 6 张免邮券哦 问与答 • larisboy • 2020-07-05 23:23:10 PM • 最后回复来自 microka | 55 |
larisboy 最近回复了
127 天前 回复了 Xyg12133617 创建的主题 › 问与答 › 各位新年快乐，开工大吉 |
开工大吉！！！祝大家新的一年高升赚大发
213 天前 回复了 hfhongyan 创建的主题 › 广州 › 广州西门口工作，住同德还是鹅掌坦呀 |
中山八
238 天前 回复了 jiobanma 创建的主题 › Java › Java 程序内存不足问题求解 |
要不调低程序的所需内存，要不给宿主机加资源
247 天前 回复了 LaGeNanRen 创建的主题 › 咖啡 › 看见东方树叶躺枪，过来分享一下我的饮料榜 |
崂山神水表示要排第一
248 天前 回复了 wudaye 创建的主题 › Windows › 搞不明白 16G 内存都被啥吃了？ |
svchost.exe(netsvcs)
261 天前 回复了 ApachW 创建的主题 › 问与答 › 做了一个相亲交友小程序，求取名 |
缘
268 天前 回复了 wwwe 创建的主题 › 奇思妙想 › 摸鱼迎中秋，有奖猜数字 |
145
271 天前 回复了 HelloWorld556 创建的主题 › 职场话题 › 今天是个好日子 |
恭喜恭喜，沾沾喜气~
278 天前 回复了 nlx 创建的主题 › 分享创造 › 分享一个自己做的集任务，笔记，聊天通话于一体的协作文档工具，诚邀内测用户体验 |
BYfGWS 已用
352 天前 回复了 larisboy 创建的主题 › 问与答 › 请问大佬一个问题 [关于 Clickhouse] |
SELECT
'2022-06-18 10:10:10' AS d1,
'2022-06-20 10:10:10' AS d2,
toDate(d1) AS d1_date,
toDate(d2) AS d2_date,
addDays(d1_date, 1) AS d1_next_day,
toInt8('1') AS week_start_day,
toInt8('5') AS week_end_day,
arrayMap(x -> (x + d1_next_day), arrayFilter(x -> (week_start_day > toDayOfWeek(addDays(d1_next_day, x)) OR toDayOfWeek(addDays(d1_next_day, x)) > week_end_day),
CASE WHEN (d2_date - d1_next_day) < 0 THEN [] ELSE range(abs(d2_date - d1_next_day)) END
)) as nonworkdays,
dateDiff('minute', toDateTime(d1), toDateTime(d2)) - 24 * 60 * length(nonworkdays) AS all_minture,
CASE WHEN (week_start_day > toDayOfWeek(d1_date) OR toDayOfWeek(d1_date) > week_end_day) THEN dateDiff('minute', toDateTime(d1), addDays(toStartOfDay(d1_date), 1)) ELSE 0 END AS d1_minture,
CASE WHEN (week_start_day > toDayOfWeek(d2_date) OR toDayOfWeek(d2_date) > week_end_day) THEN dateDiff('minute', toStartOfDay(d2_date), toDateTime(d2)) ELSE 0 END AS d2_minture,
all_minture - d1_minture - d2_minture AS work_minture
2022-06-18 10:10:10 2022-06-20 10:10:10 2022-06-18 2022-06-20 2022-06-19 1 5 ['2022-06-19'] 1440 830 0 610
已用 SQL 实现，欢迎指出 BUG
'2022-06-18 10:10:10' AS d1,
'2022-06-20 10:10:10' AS d2,
toDate(d1) AS d1_date,
toDate(d2) AS d2_date,
addDays(d1_date, 1) AS d1_next_day,
toInt8('1') AS week_start_day,
toInt8('5') AS week_end_day,
arrayMap(x -> (x + d1_next_day), arrayFilter(x -> (week_start_day > toDayOfWeek(addDays(d1_next_day, x)) OR toDayOfWeek(addDays(d1_next_day, x)) > week_end_day),
CASE WHEN (d2_date - d1_next_day) < 0 THEN [] ELSE range(abs(d2_date - d1_next_day)) END
)) as nonworkdays,
dateDiff('minute', toDateTime(d1), toDateTime(d2)) - 24 * 60 * length(nonworkdays) AS all_minture,
CASE WHEN (week_start_day > toDayOfWeek(d1_date) OR toDayOfWeek(d1_date) > week_end_day) THEN dateDiff('minute', toDateTime(d1), addDays(toStartOfDay(d1_date), 1)) ELSE 0 END AS d1_minture,
CASE WHEN (week_start_day > toDayOfWeek(d2_date) OR toDayOfWeek(d2_date) > week_end_day) THEN dateDiff('minute', toStartOfDay(d2_date), toDateTime(d2)) ELSE 0 END AS d2_minture,
all_minture - d1_minture - d2_minture AS work_minture
2022-06-18 10:10:10 2022-06-20 10:10:10 2022-06-18 2022-06-20 2022-06-19 1 5 ['2022-06-19'] 1440 830 0 610
已用 SQL 实现，欢迎指出 BUG
Select Language