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 marto (Bishop)
on Nov 14, 2012 at 13:10 UTC ( #1003795=note: print w/replies, xml ) Need Help??


in reply to Not able to find dateTime value using sql

Debugging tips:

  • Run your SQL against the database, removing Perl (or whatever) from the equation. If the result isn't what you want, your SQL is most likely wrong, less likely is that there's a bug in the database product(s) you use.
  • If the SQL works as expected then examine how you manipulate the results afterwards. Basic print statements, before and after manipulation will help.
  • Debugging and Optimization from tutorials

Also, consider using DBI to interact with databases.

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

Replies are listed 'Best First'.
Re^2: Not able to find dateTime value using sql
by bimleshsharma (Beadle) on Nov 14, 2012 at 13:37 UTC
    Running command on sql is fine and giving expected value. running this command with code (given in my post) is not giving expected result. it is giving "11/09/12" instead of "11/9/2012 3:19:18.000 PM" I am using DBI.

      Your code posted does not use DBI. You've ignored the advice I gave. Given your clamed CV/resume on your homenode basic debugging should be a very famliar concept to you. Simply restating the output you get without doing any additional work, or offering any more insight into your problem isn't going to help you. See How do I post a question effectively?.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1003795]
help
Chatterbox?
[ambrus]: No, I think the timers are handled fine in the event loop, as far as I can see.
[Corion]: So far, I liked Prima quite well as it simply seems to do what I want even if it has an upside-down coordinate system. But it installs from CPAN out of the box and is cross-platform
[ambrus]: Corion: which coordinate system is the upside down one?
[Corion]: ambrus: "the other" ;) To me, "normal" for GUIs means (0,0) is left-upper corner of the monitor/window. But for Prima, the lower-left corner it is ;)

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (3)
As of 2016-12-09 10:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (150 votes). Check out past polls.