Q&A
postgres 수업중 case 함수 스크립트 자료
SELECT DATE_TRUNC(CASE WHEN '${__interval}' = '1s' THEN 'second' WHEN '${__interval}' = '1m' THEN 'minute' WHEN '${__interval}' = '1h' THEN 'hour' WHEN '${__interval}' = '1d' THEN 'day' ELSE 'hour' END, updated_at) AS time, -- query 옵션에서 interval 값보고 조절 SUM(temperature) AS total_value FROM environment_data WHERE updated_at BETWEEN $__timeFrom() AND $__timeTo() GROUP BY time ORDER BY time;
- Likes
- 0
- Comments
- 1
- Viewcount
- 66