Re^5: Question regarding Time::Piece and timezones


No such thing as a small change
	PerlMonks

Re^5: Question regarding Time::Piece and timezones

by Marshall (Canon)

on Jan 23, 2021 at 02:44 UTC ( [id://11127324]=note: print w/replies, xml )

Need Help??

in reply to Re^4: Question regarding Time::Piece and timezones
in thread Question regarding Time::Piece and timezones

I guess that what this nets out to, is that if you log a "local time", you also need the time_zone.

I am in the US Pacific Time Zone (PST).
Once per year, a "day" will have 25 hours.
My wristwatch will wind up showing 1:15 AM twice during that day.
It is Ok that 1:15 AM PST and 1:15 AM PDST converts to a different GMT time,
but the time zone matters.

I recommend converting all times to GMT/UTC within the DB.