Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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

by 1nickt (Abbot)
on Aug 27, 2015 at 13:42 UTC ( #1140204=note: print w/replies, xml ) Need Help??


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

Even a broken clock is right once every 86400 seconds. But did you read and follow the other advice given in response to your question, where a number of experienced programmers explained how you can create a function in your SQL?


The way forward always starts with a minimal test.
  • Comment on Re^3: Interpolating subroutine call in SQL INSERT INTO SELECT statement
  • Download Code

Replies are listed 'Best First'.
Re^4: Interpolating subroutine call in SQL INSERT INTO SELECT statement
by chacham (Prior) on Aug 27, 2015 at 17:01 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
      ... 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.

        I use the 24-hour clock on my wristwatch and all my clocks

        That looks really confusing. Is it easy to switch?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2019-07-16 04:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?