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

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

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.

Comment on Re^5: Interpolating subroutine call in SQL INSERT INTO SELECT statement Select or Download Code

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom