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

Re: Not able to find dateTime value using sql

by sundialsvc4 (Abbot)
on Nov 14, 2012 at 22:27 UTC ( #1003896=note: print w/replies, xml ) Need Help??

in reply to Not able to find dateTime value using sql

The entire problem here (seems to me at first glance to be) a matter of, first, getting the executed command to generate the full datetime value as a string; and, second, interpreting that string.   All of which ceases to be a problem when you approach the task using DBI.   Now, you can obtain the value directly, i.e. in binary form.   And you’re not executing any shell-command to do it, which can very quickly become prohibitive, say in a loop.   So, to me, this logic as-conceived definitely should be abandoned, not patched.

  • Comment on Re: Not able to find dateTime value using sql

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1003896]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (6)
As of 2018-07-17 11:52 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (363 votes). Check out past polls.