timestamp

*문제 cast로 timestamp 형변환 후 avg값을 구하려고 했는데 2day 28:40:00 처럼 시간값이 이상하게 나오는 문제가 발생함. *예시 select avg(A) from ( select (cast( start_time as timestamp) - cast( end_time as timestamp)) as A from table_name ) as example *해결 justify_interval(interval) justify_interval을 사용해서 시간값으로 계산하게 해서 해결 select justify_interval(avg(A)) from ( select (cast( start_time as timestamp) - cast( end_time as timestamp)) as A f..