Re^4: Interpolating subroutine call in SQL INSERT INTO SELECT statement

Even a broken clock is right once every 86400 seconds.

I appreciate your attempt to paraphrase Lewis Carroll's "The Two Clocks". Though, i see attribution to Marie von Ebner-Eschenbach as well.

The idea is, it is correct twice every day, assuming a 12-hour clock. However, due to the leap second a "day" might take 86,401 seconds. Therefore, while correct twice a day, it may only be once in any given 86,400 seconds.

Comment on Re^4: Interpolating subroutine call in SQL INSERT INTO SELECT statement

Replies are listed 'Best First'.
Re^5: Interpolating subroutine call in SQL INSERT INTO SELECT statement by 1nickt (Canon) on Aug 28, 2015 at 06:33 UTC
I use the 24-hour clock on my wristwatch and all my clocks ... now do you, as a Perl programmer, know off the top of your head how many seconds are in 12 hours? Probably not, because it is a useless unit! But I bet you knew 86400 seconds in a day :-) As for leap seconds; ugh. `perl -MDateTime -E' say DateTime->new(time_zone=>"UTC",year=>1972,month=>12,day=>31,hour=> +23,minute=>59,second=>60)->add(months=>$_)->month_name for (0,1); ' December February` [download] ... we escaped this year because July is longer than June (hmm, I wonder if that's why they moved it to June?): `perl -MDateTime -E' say DateTime->new(time_zone=>"UTC",year=>2015,month=>6,day=>30,hour=>2 +3,minute=>59,second=>60)->add(months=>$_)->month_name for (0,1); ' June July` [download] The way forward always starts with a minimal test.	[reply] [d/l] [select]
Re^6: Interpolating subroutine call in SQL INSERT INTO SELECT statement by chacham (Prior) on Aug 28, 2015 at 14:16 UTC
I use the 24-hour clock on my wristwatch and all my clocks That looks really confusing. Is it easy to switch?	[reply]
Re^7: Interpolating subroutine call in SQL INSERT INTO SELECT statement by 1nickt (Canon) on Sep 01, 2015 at 16:45 UTC
You're right; it does take some working out. Maybe I'll switch to the Happy Hour Timepieces "Ish" and keep things simple. The way forward always starts with a minimal test.	[reply] [d/l]