Beefy Boxes and Bandwidth Generously Provided by pair Networks chromatic writing perl on a camel
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Not able to find dateTime value using sql

by bimleshsharma (Beadle)
on Nov 14, 2012 at 12:17 UTC ( #1003790=perlquestion: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    trade_time
11/9/2012 3:19:18.000 PM
11/9/2012 6:33:06.000 PM
11/9/2012 3:19:18.000 PM
  2. or download this
    11/9/2012
  3. or download this
    $original_tradeTime= qx!kfsql -S SERVER -D big -F e -s , -c \"select t
+op 1 *,convert(datetime,trade_time) from trx where trade_id = 123\"!;
   chomp $original_tradeTime;
   $original_tradeTime =~ s/\"//g;
   print "\noriginal_tradeTime=$original_tradeTime";

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1003790]
Front-paged by Arunbear
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2013-05-23 00:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best material for plates (tableware) is:









    Results (473 votes), past polls