Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Not able to find dateTime value using sql

by space_monk (Chaplain)
on Nov 14, 2012 at 12:49 UTC ( #1003791=note: print w/ replies, xml ) Need Help??


in reply to Not able to find dateTime value using sql

You really should be using some of the DB libraries instead of executing a shell command to access the database.

Are you sure the command is actually returning a full datetime? After all, chomp only removes the ending record separator (line feeds) and the s// statement only removes quote marks, leading me to believe the output of your SQL is incorrect.

A Monk aims to give answers to those who have none, and to learn from those who know more.


Comment on Re: Not able to find dateTime value using sql
Re^2: Not able to find dateTime value using sql
by bimleshsharma (Beadle) on Nov 14, 2012 at 13:08 UTC
    Yes, SQL output is not correct if running with code. While same sql query is returning fine at sql command prompt.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2015-07-02 21:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (45 votes), past polls