zaclingen_zips

Discussions

Bug / Incorrect behavior with Convert_TZ() in MagicETL
TL;DR - The covert_tz() is subtracting an additional 5 hours when trying to convert a date/time value in UTC back to its original ET. I have a record that occurred on July 31, 2023 at 08:00:29pm, when recorded in UTC this is '2023-08-01T00:00:29.000Z'. This record has 'America/New_York' as a value in timezone . I wanted to…
WEEKOFYEAR() should be removed from the approved function list or it's behavior should be changed
Having a function to act as a synonym for another function is pretty misleading. Especially when that functionality is different from other implementations of the function. Make it so WEEKOFYEAR() returns the week number for a given date while assuming the week starts on Monday. Otherwise the function should be deprecated.

Bug / Incorrect behavior with Convert_TZ() in MagicETL
TL;DR - The covert_tz() is subtracting an additional 5 hours when trying to convert a date/time value in UTC back to its original ET. I have a record that occurred on July 31, 2023 at 08:00:29pm, when recorded in UTC this is '2023-08-01T00:00:29.000Z'. This record has 'America/New_York' as a value in timezone . I wanted to…
WEEKOFYEAR() should be removed from the approved function list or it's behavior should be changed
Having a function to act as a synonym for another function is pretty misleading. Especially when that functionality is different from other implementations of the function. Make it so WEEKOFYEAR() returns the week number for a given date while assuming the week starts on Monday. Otherwise the function should be deprecated.