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.
Comment on Re^2: Not able to find dateTime value using sql
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?.