mreinsch - Network

It's amazing we're still using CSVs as an industry - and the creativity (laziness?) some companies have in producing them.The csv...

It's amazing we're still using CSVs as an industry - and the creativity (laziness?) some companies have in producing them.

The csv parser in #ruby so far was able to handle it all - but now I've encountered a case where it didn't work as "expected". After spending some time trying to debug this, I've decided to file an issue with my findings so far: https://github.com/ruby/csv/issues/291

#csv #madness #ruby #debug is pretty awesome

One last thing on dealing with timezones, I wish I had found / looked at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones...

One last thing on dealing with timezones, I wish I had found / looked at https://en.wikipedia.org/wiki/List_of_tz_database_time_zones earlier...

Diving deeper into this timezone madness, it's indeed intentional, as described here: https://en.wikipedia.org/wiki/Tz_database#AreaAll...

Diving deeper into this timezone madness, it's indeed intentional, as described here: https://en.wikipedia.org/wiki/Tz_database#Area

All I wanted was to use a non-DST timezone as an offset to UTC to run some daily actions at different times for different parts of the world. Which sounds easy enough - but as it seems impossible to simply say "use "+0900" as a timezone, one must somehow figure out to use "Etc/GMT-9".

seems it's intentional as in https://github.com/eggert/tz/blob/5659c5322976ea171e6a5afe14e9bc8172a51e24/etcetera#L36 - but seems...

seems it's intentional as in https://github.com/eggert/tz/blob/5659c5322976ea171e6a5afe14e9bc8172a51e24/etcetera#L36 - but seems everyone else decided to move on from whatever POSIX decided?!

I'm very confused by https://github.com/tzinfo/tzinfo in #ruby right now.Examples:TZInfo::Timezone.get("Etc/GMT+9").now =>...

I'm very confused by https://github.com/tzinfo/tzinfo in #ruby right now.

Examples:

TZInfo::Timezone.get("Etc/GMT+9").now
=> 2023-11-07 05:51:37.361671 -0900

TZInfo::Timezone.get("Asia/Tokyo").now
=> 2023-11-07 23:52:19.065061 +0900

according to Wikipedia (https://en.wikipedia.org/wiki/GMT%2B9) and other sources it seems that tzinfo uses opposite signs than it should be using?