Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

[REFACTOR] 블랙홀 컬럼 추출 #14

Open
kenu opened this issue Apr 23, 2021 · 0 comments
Open

[REFACTOR] 블랙홀 컬럼 추출 #14

kenu opened this issue Apr 23, 2021 · 0 comments

Comments

@kenu
Copy link
Contributor

kenu commented Apr 23, 2021

select username, active, blackholed_at, datediff(blackholed_at, now()) toblack from
(select username, active,
str_to_date(json_extract(data, '$.cursus_users[1].blackholed_at'),'"%Y-%m-%dT%T.%fZ"') blackholed_at
from users where active = true) a
where datediff(blackholed_at, now()) > -10

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant