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 occurred_at) - occurred_at AS next_event,