MySQL과 PostgreSQL의 시간문법 차이
MySQL SELECT TIMESTAMPDIFF(SECOND, last_event_timestamp, event_timestamp_kst) AS last_event, TIMESTAMPDIFF(SECOND, event_timestamp_kst, next_event_timestamp) AS next_event, TIMESTAMPDIFF(단위, 시간1, 시간2) : 시간2 - 시간1을 단위별로 계산해준다. PosgreSQL SELECT occurred_at - LAG(occurred_at, 1) OVER (PARTITION BY user_id ORDER BY occurred_at) AS last_event, LEAD(occurred_at, 1) OVER (PARTITION BY user_id ORDER BY ..
SQL/MySQL과 Postgre SQL의 차이점
2022. 8. 24. 21:28