Skip to content

Instantly share code, notes, and snippets.

@ctkdev

ctkdev/EasternToUTC_2021_2022.sql

Created October 26, 2022 18:22
Show Gist options
  • Save ctkdev/6a0764c778641bbecd5dc1c83a7525ef to your computer and use it in GitHub Desktop.
Save ctkdev/6a0764c778641bbecd5dc1c83a7525ef to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ctkdev created this gist Oct 26, 2022.
    12 changes: 12 additions & 0 deletions EasternToUTC_2021_2022.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    # https://www.timeanddate.com/time/change/usa
    select dateTimeAccess dateTimeAccessEastern,
    CASE
    when dateTimeAccess between '2021-03-14 02:00:00' and '2021-11-07 02:00:00' then DATE_FORMAT(
    DATE_ADD(dateTimeAccess, INTERVAL 4 HOUR), '%Y-%m-%d %H:%i:%s')
    when dateTimeAccess between '2021-11-07 02:00:01' and '2022-03-13 02:00:00' then DATE_FORMAT(
    DATE_ADD(dateTimeAccess, INTERVAL 5 HOUR), '%Y-%m-%d %H:%i:%s')
    when dateTimeAccess > '2022-03-13 02:00:01' then DATE_FORMAT(
    DATE_ADD(dateTimeAccess, INTERVAL 4 HOUR), '%Y-%m-%d %H:%i:%s')
    end as dateTimeAccessUTC
    from all_logs
    order by dateTimeAccess;