Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. IF DATETIME([timestamp]) >= DATETIME(STR(YEAR(date([timestamp]))) + '-03-' +
  2. STR(IF DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-03-01')) = 1
  3. THEN 9
  4. ELSE 16
  5. END - DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-03-01'))) + ' 08:00:00')
  6. AND DATETIME([timestamp]) < DATETIME (STR(YEAR(date([timestamp]))) + '-11-' +
  7. STR(IF DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-11-01')) = 1
  8. THEN 2
  9. ELSE 9
  10. END - DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-11-01'))) + ' 08:00:00' )
  11. THEN DATEADD('hour', -5, DATETIME([timestamp]))
  12. ELSE DATEADD('hour', -6, DATETIME([timestamp]))
  13. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement