Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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

by 1nickt (Abbot)
on Aug 28, 2015 at 06:33 UTC ( #1140287=note: print w/replies, xml ) Need Help??


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
... 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


The way forward always starts with a minimal test.

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?

      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1140287]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2019-07-21 18:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If you were the first to set foot on the Moon, what would be your epigram?






    Results (9 votes). Check out past polls.

    Notices?