V2EX › larisboy 的所有回复 › 第 3 页 / 共 5 页

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

现在注册

已注册用户请登录

1 2 3 4 5

❮

❯

2022-08-30 15:18:53 +08:00

回复了 nlx 创建的主题 › 分享创造 › 分享一个自己做的集任务，笔记，聊天通话于一体的协作文档工具，诚邀内测用户体验

BYfGWS 已用

2022-06-17 14:54:26 +08:00

回复了 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-17 11:32:06 +08:00

回复了 larisboy 创建的主题 › 问与答 › 请问大佬一个问题 [关于 Clickhouse]

@aimiyooo 好的，我试试

2022-06-17 11:12:18 +08:00

回复了 larisboy 创建的主题 › 问与答 › 请问大佬一个问题 [关于 Clickhouse]

@panpanpan 感觉应该是可以的

2022-06-17 11:03:35 +08:00

回复了 larisboy 创建的主题 › 问与答 › 请问大佬一个问题 [关于 Clickhouse]

有大佬能解答一下吗

2022-05-12 20:53:50 +08:00

回复了 mooniitt 创建的主题 › Bitcoin › 比特币开始暴跌了

各位大佬现在哪个平台可以买币啊