Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1003896]
help
Chatterbox?
[LanX]: more often for some weeks now
[Corion]: I think I'll have to manually (as god) intervene with that node, as the simple reparenting didn't seem to fix the parent/child relationship of the nodes
[Corion]: I think I have an idea but I'll have to open a ticket with Pair.com on that - hopefully I get to that on the weekend
LanX imagines a burning thorn bush
[Mr. Muskrat]: Thank you!
[Mr. Muskrat]: Oh that is odd. I got the message that it was reparented but yeah, it didn't actually do it. lol
[Corion]: LanX: No, Co-Rion appears as Monkey God :-)
[Corion]: Mr. Muskrat: Yeah, that message is automatic when the "normal" reparenting is done, but I think some rows that make up the node were not added to the DB properly

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (12)
As of 2017-01-19 16:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (170 votes). Check out past polls.