Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF DATETIME([timestamp]) >= DATETIME(STR(YEAR(date([timestamp]))) + '-03-' +
- STR(IF DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-03-01')) = 1
- THEN 9
- ELSE 16
- END - DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-03-01'))) + ' 08:00:00')
- AND DATETIME([timestamp]) < DATETIME (STR(YEAR(date([timestamp]))) + '-11-' +
- STR(IF DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-11-01')) = 1
- THEN 2
- ELSE 9
- END - DATEPART('weekday', DATE(STR(YEAR(date([timestamp]))) + '-11-01'))) + ' 08:00:00' )
- THEN DATEADD('hour', -5, DATETIME([timestamp]))
- ELSE DATEADD('hour', -6, DATETIME([timestamp]))
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement